RE: Free space below HWM

From: Weaver, Walt <wweaver_at_rightnowtech.com>
Date: Mon, 24 Jul 2000 11:09:57 -0600
Message-Id: <10568.112765@fatcity.com>

Check out Doc ID 77635.1, "How to determine real space used by a table
(below the HWM)" on Metalink. It will tell you just about everything you
need to know, and includes SQL scripts.

--Walt Weaver
  Bozeman, Montana

-----Original Message-----
From: Aldi Barco [mailto:ipal_at_hotmail.com] Sent: Monday, July 24, 2000 10:34 AM
To: Multiple recipients of list ORACLE-L Subject: Free space below HWM

Hi list,

Because of delete operations, some tables in my database has a lot of free space below High Water Mark. For example for a table, HWM is 400 MB but the number of record is just about 2000. I try Select count(*), it takes time too long.
How to know how much is unused space below high water mark ? (for a table and index as well, because I want to know which index that has been candidate for rebuild).

Thank you.

Aldi
Oracle DBA

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

-- 
Author: Aldi Barco
  INET: ipal_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Jul 24 2000 - 12:09:57 CDT