1、查询Oracle数据字典缓存命中率:
select (1-(sum(getmisses)/sum(gets))) * 100 "Hit Ratio" from v$rowcache;
2、查询Oracle的latch命中率:
select 1-sum(misses)/sum(gets) from v$latch;
3、查看Oracle的buffer pool命中率:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28408358/viewspace-764436/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28408358/viewspace-764436/