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
Next» Tuning Oracle Buffer Cache