Into the Shared Pool - An In Depth Look at Tuning the Shared Pool (Part 2)
Oracle Tips by Mike Ault
Guideline 3: If the shared pool shows that no
reusable SQL is being used establish a shared pool large enough to
hold the fixed size portions plus a few megabytes (usually not more
than 40) and allow the shared pool modified least recently used (LRU)
algorithm to manage the pool.
Let us continue this month furthering the
discussion of what to pin and look at other areas of shared pool
tuning such as multi-threaded server, hashing and the generalized
tuning of the library and data dictionary cache areas.
SEE CODE DEPOT FOR FULL SCRIPTS
||If you like
Oracle tuning, you may enjoy the book
Oracle Tuning: The Definitive Reference
, with over 900 pages of BC's favorite tuning tips &
You can buy it directly from the
publisher and save 30%, and get instant access to the code
depot of Oracle tuning scripts.
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today.