Re: AWR report

Without know what *else* was running at that time, it is only possible to guess. Having the complete AWR report (from both nodes, and assuming 10g) may help. Specifically, look at the last few sections of a RAC AWR report that lists type and statistics of GC traffic.

John

On Sat, Mar 13, 2010 at 12:15 PM, K R <kp0773_at_gmail.com> wrote:

> Hi,
>
> 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
>
>
>
>
>

-- 
John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

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