Re: Preventing delayed block cleanout due to loading a datawarehouse

From: Randolf Geist <>
Date: Tue, 19 Apr 2011 05:27:49 -0700 (PDT)
Message-ID: <>

On Apr 19, 1:08 pm, Donatello Settembrino <> wrote:
> I do not think that in my tests are chained rows.

Thanks, I assumed a 8KB default block size but you seem to have 16KB according to the output, given the default PCTFREE of 10 (I don't see any non-default setting in your CREATE TABLE statement) your 4 times 4000 bytes must be very close to the limit of free space available in a 16KB block...

Randolf Received on Tue Apr 19 2011 - 07:27:49 CDT

Original text of this message