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>


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-l
Received on Thu Jan 17 2008 - 17:11:41 CST

Original text of this message