RE: Free space below HWM

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 25 Jul 2000 03:56:56 +1000
Message-Id: <10568.112773@fatcity.com>

Hello Aldi,

If you have analyzed the schema, then you can get what you need from the statistics.
Have a look at the sparse_tables.sql and sparse_indexes.sql scripts on my web site
for an example of how it can be done.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Aldi Barco Sent: Tuesday, 25 July 2000 2:34
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:56:56 CDT