From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Freelists Date: Wed, 8 Aug 2001 12:15:43 +0100 Message-ID: <997269171.24907.0.nnrp-13.9e984b29@news.demon.co.uk> References: <645b6e08.0108080251.4b44c5d8@posting.google.com> 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 997269171 nnrp-13:24907 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: 29 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@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.