Re: free space in an extent below High Watermark

j.w.vandijk.removethis_at_hetnet.nl (Jaap W. van Dijk) wrote in message news:<3ce41fbd.3665821_at_news.jaapwvandijk.myweb.nl>...
> A word of caution: the procedure UNUSED_SPACE will give you the free
> space above the HWM, FREE_BLOCKS will give you the number of blocks of
> which the contents has dropped below PCT_USED, but these blocks could
> all be filled up to PCT_USED or could all be empty, so that in itself
> doesn't say much about the total space that is free below the HWM.
>
> Jaap.
>
> On Thu, 16 May 2002 17:31:12 +0200, Sybrand Bakker
> <postbus_at_sybrandb.demon.nl> wrote:
>
> >On 16 May 2002 07:07:22 -0700, frankzaum_at_yahoo.de (Frank Zaum) wrote:
> >
> >>Hello,
> >>
> >>@ Oracle 8.1.7:
> >>i create a table XXX and add 10000 rows to it, then delete all of the
> >>rows from that table. After that i use SQL*Loader to insert another
> >>10000 rows into
> >>that table. I guess the HWM block should now be twice as 'high' as
> >>after the delete, though still only 10000 rows populate the table.
> >>
> >>Question: can i find out how many space BELOW the HWM is free?
> >>
> >>TIA
> >>
> >>Frank Zaum, Salzgitter.
> >
> >
> >Please refer to the doco for the dbms_space package, calling that
> >package will return the info you want.
> >
> >Hth
> >
> >Sybrand Bakker, Senior Oracle DBA
> >
> >To reply remove -verwijderdit from my e-mail address

Hi again,

DBMS_SPACE does not give me the information i want, select count( distinct ROWID ) is too slow...

please help... thx,

Frank Zaum Received on Fri May 17 2002 - 02:54:44 CDT