Re: free space in an extent below High Watermark

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 16 May 2002 17:31:12 +0200
Message-ID: <t4k7eu4616gbdt7l24uf3ae3jnblm0h51k@4ax.com>

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 - 10:31:12 CDT