How to find the parallelism degree of a query that has been finished?(on 10.2)

One of my DBA colleague asked me this question today but I couldn't come up
with a dictionary view for this kind of a need. Since he was on 10.2 and has
AWR as a cost option we worked on this SQL;

*SELECT qc_session_id,
       sql_id,
       to_char(sample_time,
               'dd.mm.yyyy hh24:mi:ss'),
       COUNT(*) potantial_dop
  FROM dba_hist_active_sess_history
 GROUP BY qc_session_id,
          sql_id,
          to_char(sample_time,
                  'dd.mm.yyyy hh24:mi:ss')
 ORDER BY 4 DESC;
*
Depending on the type of SQL this query sould be equal to DOP+1 or DOP*2+1,
assuming that you have the timing and the sql_id of the query you are after
this may help but I wanted to have your comments and ideas on this topic.

Thank you.

-- 
Best Regards,
H.Tonguç YILMAZ

http://vimeo.com/user983017/videos
http://tonguc.yilmaz.googlepages.com/

Other related posts: