Re: free space in an extent below High Watermark

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
Received on Thu May 16 2002 - 16:12:41 CDT