The answer is that
free list handling is overhead, which means that the database is working on
its own structures and not working on the user data. It's easy to conceive a
busy transaction table to which records are frequently added and from which
they're frequently removed. Having only one parameter would significantly
increase the amount of time spent in moving blocks to and from the free list,
and significantly increase the overhead. You can test it by setting up a table
with PCTFREE+PCTUSED=100. In other word, the answer to your question is that
two parameters are needed to reduce the overhead of the free list maintenance.
By the way, I just wanted to let you know I tried that PCTFREE+PCTUSED=100
I used PCTFREE 40 and PCTUSED 60 on a specific table space, and created
a table there which I updated/deleted records quite a bit, but I didnt see much
of a difference. It might have been because there werent many people
on the system at the time.
thx maa
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
