Working out which part of an explain plan is being currently executed

From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Wed, 23 Jan 2013 07:03:57 -0800 (PST)
Message-ID: <61d8ad01-aad9-4c09-a9da-8fa530a6521f_at_4g2000yqv.googlegroups.com>

I have a big query running / as a starting point i would like to drill down and work out which execution steps are currently being executed...
...or which objects are being accessed

this may give me a starting point to analyzing potential for performance improvement. My query has been running for a day

I have tried tracing but just get a load of wait events ( see below )
..my only general gut feeling is that nested loops may be wronglly
selected

Any pointers or suggestions for further education gratefully received

regards
Chris B

AIT #1188826856: nam='PX Deq: Execute Reply' ela= 6555 sleeptime/ senderid=200 passes=1 p3=0 obj#=-1 tim=1729507286272 WAIT #1188826856: nam='PX Deq: Execute Reply' ela= 13407 sleeptime/ senderid=200 passes=1 p3=0 obj#=-1 tim=1729507299754 WAIT #1188826856: nam='PX Deq: Execute Reply' ela= 19983 sleeptime/ senderid=200 passes=1 p3=0 obj#=-1 tim=1729507319871 WAIT #1188826856: nam='PX Deq: Execute Reply' ela= 6461 sleeptime/ senderid=200 passes=1 p3=0 obj#=-1 tim=1729507326459 WAIT #1188826856: nam='PX Deq: Execute Reply' ela= 25443 sleeptime/ senderid=200 passes=1 p3=0 obj#=-1 tim=1729507352001 WAIT #1188826856: nam='PX Deq: Execute Reply' ela= 12178 sleeptime/ senderid=200 passes=1 p3=0 obj#=-1 tim=1729507364343 Received on Wed Jan 23 2013 - 16:03:57 CET