| Hit Ratio [message #53700] |
Sun, 06 October 2002 13:46  |
Rizwan Qazi
Messages: 135
Registered: August 2002
|
Senior Member |
|
|
I executed the following query on a DB instance
select 1-(phy.value / (cur.value + con.value)) "Cache
Hit Ratio",
round((1-(phy.value / (cur.value + con.value)))*100,2)
"% Ratio"
from v$sysstat cur, v$sysstat con, v$sysstat phy
where cur.name = 'db block gets' and
con.name = 'consistent gets' and
phy.name = 'physical reads'
/
got the following for hit ratio. Does anyone know how
I can make this go back to 95%+?
Thanks
Riz
|
|
|
|
| Re: Hit Ratio [message #53707 is a reply to message #53700] |
Sun, 06 October 2002 22:36  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
We don't see the "following hit ratio". What is it?
Higher than 95% and you are trying to go back to 95%, or lower than 95% and you are trying to go forward to 95%? I guess, you can clarify that.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
