Re: Big RAC Benchmark Performance Tips?

  • From: Mogens Nørrgaard <mln@xxxxxxxxxxxx>
  • To: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
  • Date: Wed, 02 Aug 2006 22:47:05 +0200

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

          -------------------------------------------------------------


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


Other related posts: