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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 19 Feb 2009 19:17:42 +0000
Message-ID: <7765c8970902191117x30fbdabfu3e1442ffaedfc62c_at_mail.gmail.com>



I'm pretty sure that you could use Dbms_xplan to explain from the shared pool on that version. I cant confirm on this nokia phone though!

On 2/19/09, H.Tonguç YILMAZ <tonguc.yilmaz_at_gmail.com> wrote:
> 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/
>

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 19 2009 - 13:17:42 CST

Original text of this message