Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: free space in an extent below High Watermark

Re: free space in an extent below High Watermark

From: Gaurang Patel <gvpatel_at_hotmail.com>
Date: 17 May 2002 06:22:14 -0700
Message-ID: <14133c52.0205170522.634b264f@posting.google.com>


frankzaum_at_yahoo.de (Frank Zaum) wrote in message news:<4c1e5bbe.0205160607.64c3145c_at_posting.google.com>...
> 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.

I THINK IF YOU DELETE ROWS FROM TABLE.ALL BLOCKS BECOME AVAILABLE IN FREELIST SO THEY WILL BE REUSED IN TABLE. HIGH WATER MAKE WON'T BE DOUBBLE Received on Fri May 17 2002 - 08:22:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US