Re: Free space below HWM

go to $ORACLE_HOME/rdbms/admin

look for dbmsutil.sql

in there is dbms_space package, thats what you'll want to use to see how much "free" space there is between last data block used(ie: with data) and the HWM.

joe

Aldi Barco wrote:

> 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:20:33 CDT