select a.value + b.value "logical_reads",
round(100 * ((a.value+b.value)-c.value) /
"BUFFER HIT RATIO"
from v$sysstat a, v$sysstat b, v$sysstat c
a.statistic# = 38
b.statistic# = 39
c.statistic# = 40;
WITH dB_CACHE_SIZE =712M IS IT STILL TOO SMALL???
logical_reads phys_reads BUFFER HIT RATIO
8982109 39133012 -336
just want to confirm with you guys
Last edited by learning_bee; 01-17-2005 at 03:31 PM.
Learning_bee, which version of Oracle database are you using? If I remember correctly from your previous posts, you are using 9i (probably rel.2). So have you checked within your database, what those statistic# from your query actualy corresponds to?
I'm almost certain you are computing your buffer cache hit ration from the statistics about "gcs messages sent" (#38), "ges messages sent"(#39) and "db block gets"(#40). Those are definitely excelent imput data for your formula!!!
As pando allready adviced you once: use some common sence from time to time. Don't blindly follow everything that you find somewhere on the net or in books, try also to understand the logic behind that.
P.S. Those statistics numbers were valid for the buffer cache hit ratio components in 8i.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
first of all, thanks so much for all of the advises and time you guys are putting into this forum.
The reason I did ask those questions b/c I am new with PT, I read so many docs from Oracle and books and sometime it confused me so that may be I didn't ask the proper question and I apologize for that. I myself still try to learn from you guys and reading more books so hopefully one day it will be clearer.
I have performance problem with one of my database and I am trying to solve it. Right now, I am suspecting two problems on my database, one is I/O and the second one is LOCKING. I am still trying to see where and what part has been locking so I am digging and digging and sometime may be annoyingn to you guys. I apologize.
If you can give me direction so how to ping point the locking method, I would great appreciate ( I did find some articles on metalink but they are not too clear for me).