Question re: PCTFREE

From: Leslie Tierstein <Leslie.Tierstein_at_visionchain.com>
Date: Fri, 9 Apr 2004 11:19:24 -0400
Message-ID: <MBEKKMMKENFAJFKKNHDOCEJJCBAA.Leslie.Tierstein@visionchain.com>

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: 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 Fri Apr 09 2004 - 10:15:43 CDT