さらに細かい単位でディクショナリ・キャッシュのヒット率を知りたい
select unique parameter, gets, getmisses,
gets/(gets+getmisses)*100 "% Miss"
from v$rowcache
where gets+getmisses != 0
order by 1;
Japanese | English
select unique parameter, gets, getmisses,
gets/(gets+getmisses)*100 "% Miss"
from v$rowcache
where gets+getmisses != 0
order by 1;