Sunday 12 December 2010

Data Dictionary Cache Hit ratio

SELECT SUM(PINS) / (SUM(PINS) + SUM(RELOADS)) * 100
FROM V$LIBRARYCACHE;

If this value is greater than 1% then increase SHARED_POOL_SIZE

No comments:

Post a Comment

Number of Visitors