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
Advertisement
Hi all,
We are getting Negative values of Library cache hit ratio in AWR Report of 11g(11.2.0.3) 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
Regards,
Madhan
Edited by: user12078989 on Jul 25, 2012 7:40 AM
Advertisement
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?

2015-10-11

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

-0001-11-30

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'

-0001-11-30

Using: Oracle 10.2.0.1.0, 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

-0001-11-30

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

-0001-11-30

Hi, I would appreciate some advice please. My Oracle 10.2.0.4.0 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%)

-0001-11-30

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 http://www.oracledba.co.

Buffer Cache Hit ratio 48

-0001-11-30

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%)

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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?

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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

-0001-11-30

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