Tuning Shared Pool

select NAMESPACE,
GETS,
GETHITS,
round(GETHITRATIO*100,2) gethit_ratio,
PINS,
PINHITS,
round(PINHITRATIO*100,2) pinhit_ratio,
RELOADS,
INVALIDATIONS
from v$librarycache

SELECT shared_pool_size_for_estimate "Size of Shared Pool in MB",
shared_pool_size_factor "Size Factor",
estd_lc_time_saved "Time Saved in sec"
FROM v$shared_pool_advice;


Good reply bor Johthan Lewis
http://forums.oracle.com/forums/thread.jspa?threadID=587990&tstart=0


V$LIBRARYCACHE
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/hayden/libcache.html

How to Calculate Your Shared Pool Size
Note: 1012046.6


Good doc on tuning shared pool
Metalink doc: 62143.1

Shared Pool Information
http://vsbabu.org/oracle/sect13.html

Unserstaing shared pool
http://download-uk.oracle.com/oowsf2005/003wp.pdf

Oracle Tuning from Uni
http://www.uaex.edu/srea/tuning.htm


Shared Pool Advisory
====================

SHOW PARAMETER statistics_level;

SELECT shared_pool_size_for_estimate,
shared_pool_size_factor,
estd_lc_time_saved
FROM v$shared_pool_advice;

http://www.dbasupport.com/oracle/ora9i/shared_pool.shtml

http://www.orafaq.com/scripts/performance/orayaps.txt