Re: Alternative to V$PQ_TQSTAT for troubleshooting unbalanced HJs?

this is a nice coincidence - I might have exactly what you need in such cases where Real-Time SQL Monitoring and V$PQ_TQSTAT are of no real help.

I've just published the first public release of a SQL*Plus script called "XPLAN_ASH" that allows SQL statement execution analysis using 11g ASH data, and its primary purpose is analysing Parallel Execution and providing some details that are hard to obtain otherwise.

You can find the details how to use the tool and the download link on my blog: http://oracle-randolf.blogspot.de/2012/08/parallel-execution-analysis-using-ash.html

If you simply want to analyse the last execution of the statement, just specify the SQL_ID as parameter. If the information is no longer available from your current ASH (GV$ACTIVE_SESSION_HISTORY) you can tell the script to pull the information from DBA_HIST_ACTIVE_SESS_HISTORY.

If you are looking for a particular execution you can specify the SQL_EXEC_START and SQL_EXEC_ID that identifies that statement execution.

In your particular case you might need to play a bit with the ASH options, instead of "ASH,DISTRIB_REL,TIMELINE" you might need to use "ASH,DISTRIB,TIMELINE" instead to make a potential skew more visible - see the blog post for more details about that.

And: This is a 1.0 version - although I've used it myself a lot already, I would expect some glitches. Feedback welcome!

Hope this helps,
Randolf

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