Path: g2news1.google.com!postnews.google.com!z7g2000prh.googlegroups.com!not-for-mail
From: Randolf Geist <mah...@web.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Preventing delayed block cleanout due to loading a datawarehouse
Date: Tue, 19 Apr 2011 05:27:49 -0700 (PDT)
Organization: http://groups.google.com
Lines: 11
Message-ID: <2c1741ad-c9ec-4368-977a-39cf854d9fb8@z7g2000prh.googlegroups.com>
References: <4d9f72ff.324390@news.hetnet.nl> <00862d66-bf38-4138-82a4-4fa0d6d5afff@f11g2000vbx.googlegroups.com>
 <00d83f5f-92c9-4eb9-a2b8-e2c418d3f6a3@a26g2000vbo.googlegroups.com>
 <81b1de59-466b-4971-b2b4-378f37e16c8b@32g2000vbe.googlegroups.com>
 <6cdd8235-b880-4a41-b9d5-5821e77c031e@n2g2000prj.googlegroups.com>
 <7d38c256-a2ca-475d-a661-3b8099077de2@r6g2000vbz.googlegroups.com>
 <b525a1f5-9d73-4c58-9b39-ac22bda14ca2@v33g2000prn.googlegroups.com>
 <7c00d410-b8ac-40af-b99c-f88b5fb0e159@d12g2000vbz.googlegroups.com> <d766314d-3715-4c88-832e-003671a62a8a@i39g2000prd.googlegroups.com>
NNTP-Posting-Host: 160.83.30.197
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1303216069 10564 127.0.0.1 (19 Apr 2011 12:27:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 19 Apr 2011 12:27:49 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z7g2000prh.googlegroups.com; posting-host=160.83.30.197; posting-account=l5e9UwoAAACVOObO40ZuWRhYrDAs6n0B
User-Agent: G2/1.0
X-HTTP-Via: 1.1 webwasher (Webwasher 6.8.7.8846)
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.16)
 Gecko/20110319 Firefox/3.6.16,gzip(gfe)

On Apr 19, 1:08=A0pm, Donatello Settembrino
<donatello.settembr...@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