It goes off the free list when oracle attempts
to insert a row, and the effect of inserting that
row would take the space usage over PCTFREE.
--
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
Mick Rice wrote in message
<645b6e08.0108080251.4b44c5d8_at_posting.google.com>...
>Ok, so when a transaction is inserting rows into a block it continues
>to do so until it hits PCTFREE. When rows are being deleted, at the
>point where the block is less that PCTUSED full the block is put back
>on the freelist for that table. My question is, when is the block
>initially taken off the freelist. If it's when we pass over the
>PCTUSED point how then do we continue to insert rows up to PCTFREE.
>
>Yours Expectantly,
>
>Mick Rice.
Received on Wed Aug 08 2001 - 06:15:43 CDT
