Correct -
If there are 290 bytes of free space,
and the PCTFREE means that 200 of them
should be left free, and you try to insert a
91 byte row, then the block will be pushed
onto the free list with 290 bytes of free space
and the next block on the freelist will be
examined.
--
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
Rene Nyffenegger wrote in message ...
>
>>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.
>
>Does 'would take the space usage over PCTFREE' indicate, that
>the row is not inserted at all, if space usage goes over PCTFREE?
>My understanding until now was, that a row gets inserted into a
>block as long as space usage is below PCTFREE and the new row
>fits into the block.
>
>Rene
>
>--
>Recherchen im Schweizerischen Handelsamtsblatt:
>http://www.adp-gmbh.ch/SwissCompanies/Search.php3
Received on Wed Aug 08 2001 - 13:37:04 CDT
