Library cache miss rate
670070Oct 5 2009 — edited Oct 27 2009Hi,
I've Oracle 10.2.0.3 version database. Yesterday I checked performance of the database with couple of programs also got AWR report. Some of test programs showed "library cache miss rate error". Often we check our application codes about using bind variable, hints and so on to get best performance from the database. At the below I paste part of AWR report, could you analyze it please because I'd to know what's reason of the error.
Thanks.
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 98.60 In-memory Sort %: 100.00
Library Hit %: 98.46 Soft Parse %: 99.14
Execute to Parse %: 9.93 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 117.81 % Non-Parse CPU: 96.31