Logo Background

Oracle Library Cache Ratio

  • By on August 22, 2008 | No Comments

    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
    Previous
    Next
    » Tuning Oracle Buffer Cache
Leave a Comment