How to find the parallelism degree of a query that has been finished?(on 10.2)
From: H.Tonguç YILMAZ <tonguc.yilmaz_at_gmail.com>
Date: Thu, 19 Feb 2009 19:19:18 +0200
Message-ID: <f8e9eb670902190919q1d396595v2ed2185213d4c4a6_at_mail.gmail.com>
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;
FROM dba_hist_active_sess_history
GROUP BY qc_session_id,
*
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.
Date: Thu, 19 Feb 2009 19:19:18 +0200
Message-ID: <f8e9eb670902190919q1d396595v2ed2185213d4c4a6_at_mail.gmail.com>
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/ -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 19 2009 - 11:19:18 CST