Re: SQL*Loader performance - PCTFREE
From: <genegurevich_at_discover.com>
Date: Thu, 17 Jan 2008 17:11:41 -0600
Message-ID: <OF3F3F7155.6893E243-ON862573D3.007F2454-862573D3.007F698D@discover.com>
Date: Thu, 17 Jan 2008 17:11:41 -0600
Message-ID: <OF3F3F7155.6893E243-ON862573D3.007F2454-862573D3.007F698D@discover.com>
I just thought about something else. We currently have pctfree set to 40 in
the largest of the tables. This was done
a few month ago to deal with Oracle not being able to build bitmap indices
on this tables because they were too
fragmented. To reduce the number of records per block I have increased the
pctfree to 40. This increased the
number of blocks needed to store the table. Now I don't think we have any
more of the bitmap indices and therefore
I should be able to reduce the pctfree thus reducing the size of the table
and this should reduce the time needed
to load this table.
Does that sound reasonable?
thank you
Gene Gurevich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 17 2008 - 17:11:41 CST