Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PCTFREE and data warehousing

Re: PCTFREE and data warehousing

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Mon, 21 Jun 2004 16:01:40 -0400
Message-Id: <s0d70672.098@galottery.org>


Ben,
 As I remember the training about PCTFREE and PCTUSED, when you create a table the settings and part of the original table and blocks used up until the time you make a change in the PCTFREE and PCTUSED. After the parameters are changed any new blocks will inherit the new parameter values. The only way to correct the parameter values for the entire table is to recreate the table.
Things may have changed since the dark ages when I learned about the table parameters. I know that there is a lot to learn with the 9i and 10g databases.
Ron

>>> poelsb_at_post.queensu.ca 06/21/2004 2:22:15 PM >>>
Hi

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 
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 14:59:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US