SELECT SUM(PINS) / (SUM(PINS) + SUM(RELOADS)) * 100FROM V$LIBRARYCACHE;If this value is greater than 1% then increase SHARED_POOL_SIZE
No comments:
Post a Comment