From: mickrice@techie.com (Mick Rice)
Newsgroups: comp.databases.oracle.server
Subject: Freelists
Date: 8 Aug 2001 03:51:08 -0700
Organization: http://groups.google.com/
Lines: 10
Message-ID: <645b6e08.0108080251.4b44c5d8@posting.google.com>
NNTP-Posting-Host: 193.95.165.163
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997267868 16580 127.0.0.1 (8 Aug 2001 10:51:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 10:51:08 GMT


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.