By Gatot Rubianto – You need to tune the database cache hit ratio if:
the gethitratio on the library cache is > 90%
the pinhitratio on the library cache is < 1%
the get hit ratio on the dictionary cache is < 15%
Use this simple script to measure the cache hit ratio:
[membership level="0"]
[pmpro_button level="14" text="Read More - Register for Free Membership"][/membership]
[membership][standout-css3-button href="http://www.searchoracle.com/tip/1,289483,sid13_gci820946,00.html?FromTaxonomy=%2Fpr%2F286329" opennewwindow=true]Read More[/standout-css3-button] (Community content)
[/membership]