Re: RAC + cluster waits
- From: Jinwen Zou <zjworacle@xxxxxxxxx>
- To: "John.Fedock@xxxxxxxxxxxx" <John.Fedock@xxxxxxxxxxxx>
- Date: Wed, 19 Feb 2014 08:21:42 +1100
Hi John,
When the issuse repeat, how long does it last? AWR might not the tool to
troubleshot short period issue last for less than few minutes, ASH plus
v$session are the ones. You can check what the sessions were running in
troubled period, and correlate this with other instance session activities at
the same time, then you can narrow down which session/s or SQL might be the
culprit to focus on.
Regards
Jinwen
> On 19 Feb 2014, at 1:19 am, "Fedock, John (KAM.RIC)"
> <John.Fedock@xxxxxxxxxxxx> wrote:
>
> Need some advice regarding cluster wait issues on a 3 node Linux 11.2.0.3
> Oracle system.
>
> Short question – How can I determine what is causing recent cluster waits on
> our database?
>
>
> Long question – We have a mature system that has been running well for
> several years. Recently some performance issues have started and they seem
> to be related to cluster wait events.
>
> It is easy enough to see what events are waiting for clustered waits, but not
> what is causing them to wait. When we are having issues, I may see several
> dozen session waiting for 2 or 3 seconds and then they clear up, then a few
> seconds later, it repeats. I have run several awrrpt and awrgrpt and
> cannot see anything obvious.
>
> It also seems like node1 is the one that has the session waiting.
>
> Any advice?
>
>
> Thanks all.
>
> John Fedock
>
>
>
>
>
>
Other related posts:
