Re: Preventing delayed block cleanout due to loading a datawarehouse
From: Donatello Settembrino <donatello.settembrino_at_gmail.com>
Date: Tue, 19 Apr 2011 05:51:21 -0700 (PDT)
Message-ID: <fc0713f3-44f9-4067-b21e-33f6f89c1c57_at_r33g2000prh.googlegroups.com>
On 19 Apr, 14:27, Randolf Geist <mah..._at_web.de> wrote:
> 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
Date: Tue, 19 Apr 2011 05:51:21 -0700 (PDT)
Message-ID: <fc0713f3-44f9-4067-b21e-33f6f89c1c57_at_r33g2000prh.googlegroups.com>
On 19 Apr, 14:27, Randolf Geist <mah..._at_web.de> wrote:
> 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
Exactly, that's right Received on Tue Apr 19 2011 - 07:51:21 CDT