Hi Sri,
If you can identify the segments involved from the p1 and p2 parameters and put
those segments into a KEEP buffer pool you should be able to get a lot of
relief. Failing that, or if they are too big, consider either increasing
db_block_buffers if you can or setting
Hi Steve,
A couple questions: whihc p3 value is the value that indicates a need to
increase freelists? Are there any plans to adapt your freeliusts estimation
script for tables for indexes as well, or pointers on how to do so (I think
I can do a direct port to work off dba_indexes, butparts of