Re: Urgent rac wait problem
From: Jack van Zanen <jack_at_vanzanen.com>
Date: Sun, 15 Mar 2009 22:42:04 +1100
Message-ID: <77a615a70903150442u77176c63i868fd204eef05ea4_at_mail.gmail.com>
MY first guess would be if this is your top wait event that your interconnect is slow. But knowing RAC only from the theoretical and a few test installs don't take it as gospel.
Date: Sun, 15 Mar 2009 22:42:04 +1100
Message-ID: <77a615a70903150442u77176c63i868fd204eef05ea4_at_mail.gmail.com>
MY first guess would be if this is your top wait event that your interconnect is slow. But knowing RAC only from the theoretical and a few test installs don't take it as gospel.
Jack
2009/3/15 Yechiel Adar <adar666_at_inter.net.il>
> We moved from one node rac to 2 node rac.
> A simple query takes 9 seconds instead of 0.3 second.
>
> The user activated 10046 trace and I see a lot of "gc current block 2-way".
>
> Help urgently required.
>
> Adar Yechiel
> Rechovot, Israel
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Jack van Zanen ------------------------- This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation -- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 15 2009 - 06:42:04 CDT