Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Hit ratio question

Hit ratio question

From: Natarajan Malupillai <mnatty_at_ix.netcom.com>
Date: 1998/02/09
Message-ID: <34DFD69F.4ECD@ix.netcom.com>#1/1

I have a severe performance problem, the hit ratio as calculated by Method-1:
(1 - (physical rds/logical rds))*100 is about 15%
However, when i calculate hit ratio on a per user basis using the following logic:
Method -2
(1 - (physical rds/logical rds))*100

where v$session.sid=v$sess_io.sid
and username is not null
and (consistent_gets + block_gets) > 0

        i get hit ratio of near 100% for all users. To be more precise, No.of physicalreads is high in method -1 and near zero in method -2.

Could somebody help me understand this please.

Appreciate if you could send a mail!

Thanks,
Nat. Received on Mon Feb 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US