Re: Big RAC Benchmark Performance Tips?

GC is Global Cache. Try not using RAC, and see if it doesn't help.

As for the Statspack output, it's useless, but you can certainly get many (different) inputs from very good people on this list with G & M (Guesses & Grimaces).

Mogens

VIVEK_SHARMA wrote:

>
>
> Thanks Mogens, Cheng, Nial, Folks for the inputs.
>
>
>
> *Qs1 How do we address the following waits?*
>
> *Qs2 Will these supposedly cause increased CPU Usage of respective DB
> Servers?*
>
>
>
> From Statspack:-
>
>
>
> Top 5 Timed Events
> Avg %Total
>
> ~~~~~~~~~~~~~~~~~~
> wait Call
>
> Event Waits Time (s)
> (ms) Time
>
> ----------------------------------------- ------------ -----------
> ------ ------
>
> gc current multi block request 71,134
> 36 1 32.0
>
> gc buffer busy 1,446 20
> 14 17.3
>
> gc current block busy 923 14
> 15 12.5
>
> gc current grant busy 4,371
> 7 2 6.4
>
> gc cr multi block request 51,490
> 7 0 5.9
>
> -------------------------------------------------------------
>

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