Into the Shared Pool - An In Depth Look at Tuning the Shared Pool (Part 2)
Oracle Tips by Mike Ault
Guideline 5: In Oracle7 when using MTS increase
the shared pool size to accommodate MTS messaging and queuing as
well as UGA requirements. In Oracle8 use the Large Pool to prevent
MTS from effecting the shared pool areas.
Guideline 6: Use bind variables, PL/SQL
(procedures or functions) and views to reduce the size of large SQL
statements to prevent hashing problems.
Guideline 7: In a system where there is no
flushing increase the shared pool size in 20% increments to reduce
reloads and invalidations and increase object cache hit ratios.
Guideline 8: In any shared pool, if the overall
data dictionary cache miss ratio exceeds 1 percent, increase the
size of the shared pool.
guidelines and the scripts and techniques covered in this two part
article, your should be well on the way towards a well tuned and
well performing shared pools.
||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.