From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Freelists Date: Wed, 8 Aug 2001 19:37:04 +0100 Message-ID: <997295883.21086.0.nnrp-07.9e984b29@news.demon.co.uk> References: <645b6e08.0108080251.4b44c5d8@posting.google.com> <997269171.24907.0.nnrp-13.9e984b29@news.demon.co.uk> NNTP-Posting-Host: jlcomp.demon.co.uk X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41 X-Trace: news.demon.co.uk 997295883 nnrp-07:21086 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 40 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