Logo Background

Oracle Library Cache Ratio

  • The SQL below calculate the Oracle Library Cache Ratio for the Oracle Database. The result of the query should be near 0, if the ratio is larger than 1% then you have to increase the SHARED_POOL_SIZE.

    Check Library Cache Ratio

    SQL> SELECT SUM(pins) "Total Pins", SUM(reloads) "Total Reloads",
SUM(reloads)/SUM(pins) *100 libcache
FROM v$librarycache

    Related Posts

    Previous
    Next
    » Tuning Oracle Buffer Cache
Leave a Comment

Join the over 2,000 people who get free and fresh knowledge as soon as it’s published.

Subscribe Via Email

Enter your email address:

We respect your email privacy.

We promise never to rent, sell or share information we collect because that would be a violation of everything we stand for.

Period.

RSS
Copyright © 2012 All Guru