Re: Preventing delayed block cleanout due to loading a datawarehouse
From: Randolf Geist <mahrah_at_web.de>
Date: Tue, 19 Apr 2011 05:27:49 -0700 (PDT)
Message-ID: <2c1741ad-c9ec-4368-977a-39cf854d9fb8_at_z7g2000prh.googlegroups.com>
On Apr 19, 1:08 pm, Donatello Settembrino <donatello.settembr..._at_gmail.com> wrote:
> I do not think that in my tests are chained rows.
Date: Tue, 19 Apr 2011 05:27:49 -0700 (PDT)
Message-ID: <2c1741ad-c9ec-4368-977a-39cf854d9fb8_at_z7g2000prh.googlegroups.com>
On Apr 19, 1:08 pm, Donatello Settembrino <donatello.settembr..._at_gmail.com> 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