Current position:  Home > Default > Negative Values of Library Cache Hit Ratio in AWR Report

Negative Values of Library Cache Hit Ratio in AWR Report

Time:October 11
Hi all,
We are getting Negative values of Library cache hit ratio in AWR Report of 11g( with Solaris[tm] OE (64-bit).
Please suggest us why it shows negative value.
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: 99.87 Redo NoWait %: 99.99
Buffer Hit %: 92.17 In-memory Sort %: 100.00
Library Hit %: -3,321.23 Soft Parse %: 81.95
Execute to Parse %: 92.88 Latch Hit %: 95.11
Parse CPU to Parse Elapsd %: 87.25 % Non-Parse CPU: 81.39
Edited by: user12078989 on Jul 25, 2012 7:40 AM
Hi Aman,
DB not restarted during this time.. we don't have production access. we will get awr report automatically from customer daily. also i am getting issue in our local environment v$rowcache view gets values is negative for dc_users and dc_tablespaces parameter may be it's related production issue...

How can I increase my Library Cache Hit Ratio?


I was wondering if anyone can help me out regarding the values that I am getting for my Library Cache hits stats Half of the samples that I have taken on a periodic interval today have ranged from 89% to 96%. The SQL that I have used is, SELECT sysda

Buffer Cache hit Ratio


Hi All, My DB Version: 10.2.0 OS: Windows Server 2003 I run the following script to get Hit ratio's SELECT cur.inst_id, 'Buffer Cache Hit Ratio ' "Ratio", to_char(ROUND((1-(phy.value / (cur.value + con.value)))*100,2)) "Value" FROM gv$

Manual calculation of 'Buffer Cache hit ratio'


Using: Oracle, Redhat 4, 64bit. Manual calculation of 'Buffer Cache hit ratio' is very off from what it shown in statspack. Statspack shows: Instance Efficiency Percentages ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~             Buffer Nowait %:  100.

Problem with the cache hit ratio


Hello, I ma having a problem with the cache hit ratio I am geting. I am sure, 100% sure, that something has got to be wrong with the cache hit ratio I am fetching! 1) I will post the code that I am using to retrieve the cache hit ratio. I've seen abo

Buffer cache hit ratio query


Hi, I would appreciate some advice please. My Oracle database starts off in the day with a buffer cache hit ratio of almost 100% but this drops gradually in the course of the day as the system gets busier. Is this something I need to be co

Buffer Cache hit ratio low (40.42%)


Can someone help me with a good guide or advice in order to increase my Buffer Cache hit ratio? If I am not wrong databases should have +85% hit ratio for a good performance. thanksHere is a script that will bump up your BCHR

Buffer Cache Hit ratio 48


just now I have checked the buffer cache hit ratio is 48% . In my production database . is It any problem. Thank You PrasadMaybe, maybe not. You might want to post your question into a more appropriate forum : General Database Discussions Nicolas.Rea

Low database cache hit ratio (85%)


Hi Guys, I understand that high db cache hit ratio doesn't indicates that the database is healthy. The database might be doing additional "physical" reads due to un-tuned SQL. However, can explain why a low cache hit ratio might not indicate the

MaxDB Catalog cache hit ratio too low


Hello, We use Maxdb version 7.6 and 7.7 on various systems. Each week the report of EarlyWatch indicates to me that the catalog cache ratio is too low. ( < 60% ) We modified the value of parameter CAT_CACHE_SIZE of 10000 towards 20000 then 50000 then

Database Cache Hit ratio is very less


Hi All, my live database Cache Hit ratio is very less. can some one proposed relevant solution for that. SELECT (1-((phy.value-phyd.value) / (cur.value + con.value))) * 100 "Cache Hit ratio" FROM v$sysstat cur, v$sysstat con, v$sysstat phy, v$sy

Cache hit ratio on Solaris 8


I am looking for some tool that can measure cache hit ratio. (of the data cache) I am using Solaris 8 and I need to know what is the cache miss rate when I run a certain program (and this is the only program - or at least the main program, that runs

Cache hit ratio - index sql statement


I am reading the note 33833.1 on Metalink web site. I have diffult to understand the part in the last page of the note. In the last page author talk of a situation where the cache hit ratio is near 100% but the system is not good because. the author

Cache Hit Ratio -19


Hi all I am using 10gR2 on Solaris 10. My users were complaining about the DB being very slow, so I found out that the cache hit ratio is -19.113 (Courtesy TOAD). I checked the SGA and found out that the Buffer Cache was way less than the Shared Pool

Cache hit ratio


What is the difference between these two queries?? which is the cache hit ratio??? SELECT sum(gets) "GETS", sum(getmisses) "MISSES", (100*(sum(getmisses)/sum(gets))) "RATIO%" FROM v$rowcache; Result: GETS MISSES RATIO% 366606

Cache hit ratio at enterprise manager


hit ratio formula is: (logical_reads - physical_reads/logical_reads )*100 Now, if I open Oracle Enterprise Manager and goes to Instance->Configuration->Memory I can see SGA and PGA configuration. I can also see the cache hit ratio, in my case 35%, b

How to tune effectively to the buffer cache hit ratio?


We have a database with following sga sizes; shared pool : 256 MB Buffer Cache: 880 MB Large pool: 32 MB Java pool: 32 MB Total SGA: 1201.435 mb. From the health check, i found Buffer Cache Hit Ratio is giving the trouble. so, i need advice from dba

Tivolo storage manager error message is Database Cache Hit Ratio is too low


Hi  basis friends,we are performing incremental backup from mon-fri.from past two days i was getting error message as 'data base cache hit ratio is too low (97.3,98)and increase buffer pool size value.what is the problem for this error message? how c

Ecc cache hit ratio


Dear All, Where can I get the Database cache hit ratio in ECC 6.0? I upgraded from R/3 4.6C to ERP 2005, and cannot find such information in "ST04". Please help. Regards, Henryproblem resolvedRead other 2 answers

Calculate cache hit ratio


Hi, How to calculate cache hit ratio and execution time for the below query Select * from tab; NirmalFnord. Cache hit ratio is meaningless in the context of a single query. Come to that, it's meaningless in any context. Check out this handy utility f