Question re: PCTFREE

  • From: "Leslie Tierstein" <Leslie.Tierstein@xxxxxxxxxxxxxxx>
  • To: "oracle-l" <Oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 9 Apr 2004 11:19:24 -0400

I am absolutely certain I never update rows in some data warehouse FACT
tables and lookup tables. How low can I set PCTFREE? Will zero (0) work
without untoward side effects? Rows are never updated, but can be deleted
and re-inserted by the TELL process.

Background: Current table has PCTFREE of 10 and many million rows. For newly
added rows (in newly allocated extents) I would like to get read performance
enhancements by not having 10% unused space. (For the current FACT table,
the user understands that the change would not be retroactive, but would
affect only new rows.)

Thanks for your help.

Leslie "I'm not a DBA" Tierstein
Senior Consultant
Vision Chain, Inc.
The Standard for Demand Data Networks
phone: 202-261-3549

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts:

  • » Question re: PCTFREE