PCTFREE and data warehousing

  • From: "Ben" <poelsb@xxxxxxxxxxxxxxx>
  • To: "Oracle-L@Freelists. Org" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 21 Jun 2004 14:22:15 -0400


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?



Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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

Other related posts: