Re: Alternative to V$PQ_TQSTAT for troubleshooting unbalanced HJs?
From: Greg Rahn <greg_at_structureddata.org>
Date: Sat, 11 Aug 2012 15:38:06 -0700
Message-ID: <CAGXkmivVzG5soNrFaG2_EnQvSR1WSTNshcjnNeOp4YvSJxCtCg_at_mail.gmail.com>
Seeing ASH, reminds me (and maybe Randolf's stuff covers this but didnt get that far yet) but another option you can use is to look at the time series data of wait events for the each px server from ASH select program, sample_id, event from gv$active_session_history where ... and visualize it like such
http://bit.ly/PbGCg3
which gives you a per px server, per ash sample time series view. From that it should be pretty obvious if there is skew, then you would need to drill down a bit to find the plan line etc.
--
Regards,
Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> | linkedin <http://linkd.in/gregrahn>
Date: Sat, 11 Aug 2012 15:38:06 -0700
Message-ID: <CAGXkmivVzG5soNrFaG2_EnQvSR1WSTNshcjnNeOp4YvSJxCtCg_at_mail.gmail.com>
Seeing ASH, reminds me (and maybe Randolf's stuff covers this but didnt get that far yet) but another option you can use is to look at the time series data of wait events for the each px server from ASH select program, sample_id, event from gv$active_session_history where ... and visualize it like such
http://bit.ly/PbGCg3
which gives you a per px server, per ash sample time series view. From that it should be pretty obvious if there is skew, then you would need to drill down a bit to find the plan line etc.
--
Regards,
Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> | linkedin <http://linkd.in/gregrahn>
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Aug 11 2012 - 17:38:06 CDT