| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PCTFREE and data warehousing
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
-- 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
 |
 |