From: rene.nyffenegger@gmx.ch (Rene Nyffenegger) Newsgroups: comp.databases.oracle.server Subject: Re: Freelists Date: 8 Aug 2001 17:35:13 GMT Lines: 16 Message-ID: References: <645b6e08.0108080251.4b44c5d8@posting.google.com> <997269171.24907.0.nnrp-13.9e984b29@news.demon.co.uk> NNTP-Posting-Host: pop-mu-16-1-dialup-49.freesurf.ch (194.230.114.49) X-Trace: fu-berlin.de 997292113 6406044 194.230.114.49 (16 [82536]) User-Agent: Xnews/4.01.30 >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