AWR report

in one of our 2 node -RAC database in one node

I observe

Instance Efficiency Percentages (Target 100%)

  Buffer Nowait %: 92.30 Redo NoWait %: 100.00 Buffer Hit %: 218.12 In-memory Sort %: 100.00 Library Hit %: 99.07 Soft Parse %: 98.18 Execute to Parse %: 47.41 Latch Hit %: 99.74 Parse CPU to Parse Elapsd %: 1.77 % Non-Parse CPU: 88.86

Global Cache Efficiency Percentages (Target local+remote 100%)

  Buffer access - local cache %: 43.86 Buffer access - remote cache %: 2.09 Buffer
access - disk %: 54.05

and in other node I observe

Global Cache Efficiency Percentages (Target local+remote 100%)

  Buffer access - local cache %: 167.99 Buffer access - remote cache %: 51.42 Buffer access - disk %: -119.42

would appreciate any suggestion on why there is a 3 digit disk% on node 2 and a 3 digit buffer hit on node -1

Thanks

Kart

--
http://www.freelists.org/webpage/oracle-l