PCTFREE and data warehousing

From: Ben <poelsb_at_post.queensu.ca>
Date: Mon, 21 Jun 2004 14:22:15 -0400
Message-ID: <IAEFKEBFDELIGHKOHDGJOEFNFBAA.poelsb@post.queensu.ca>

I understand that PCTFREE should be set very high for data warehouse tables that are mostly just inserted (loaded) and never updated. But what happens if the PCTFREE is set to zero. I have inherited a data warehouse where all the tables were being re-created nightly and had PCTFREE=0 and PCTUSED=40.

The application has changed and now several tables have about 10% of their data deleted and re-loaded nightly. I am finding that it is not reusing the freed data blocks - it just keeps grabbing more. I can set the PCTUSED much higher to try and get the blocks in use. What I am wondering is if a block has a PCTFREE of zero and is filled by inserts, does it never make it back onto the free list?

Thanks,

Ben

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Jun 21 2004 - 13:17:54 CDT