Dictionary Cache HIT Ratio

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Mon, 16 Oct 2000 08:40:32 +0400
Message-Id: <10650.119263@fatcity.com>

Hi All,

What is the best SQL to determine Dictionary Cache Hit Ratio?

In Online manuals I found this,

select (sum(gets - getmisses - usage - fixed)) /sum(gets) " Row Cache " from v$rowcache ;

It doesn't seem to be acceptable to me ...................

I think, the better (if not best) SQL could be

select (sum(gets - getmisses - fixed)) /sum(gets - fixed) " Row Cache " from v$rowcache ;

Please correct me if I am wrong. Thanks for your opinion ...

Regards, Received on Sun Oct 15 2000 - 23:40:32 CDT