This works for me, but if it's the best way ???
SELECT
SUM(GETS) DICT_GETS ,
SUM(GETMISSES) DICT_MISSES,
SUM(GETS-GETMISSES)*100/SUM(GETS) PCT
FROM
V$ROWCACHE ;
> -----Original Message-----
> From: Rajesh Dayal [SMTP:Rajesh_at_ohitelecom.com]
> Sent: Monday, October 16, 2000 6:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Dictionary Cache HIT Ratio
>
> 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,
> Rajesh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Oct 16 2000 - 03:10:21 CDT
