Tips, information and some real-time experiences in Oracle, UNIX
Thursday, August 26, 2010
Data Dictionary Cache Hit Ratio SQL
SQL:
select ((1 - (Sum(GetMisses) / (Sum(Gets) + Sum(GetMisses)))) * 100) "Hit Rate"
from V$RowCache
where Gets + GetMisses <> 0;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment