Re: Executuon Plan for SQL profile
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Fri, 5 Jan 2018 15:14:09 -0600
Message-ID: <CAP79kiR2bjtihoEFRpcRh9UVyGPJTV6cVD5s7CkGjsOLo-30yg_at_mail.gmail.com>
Date: Fri, 5 Jan 2018 15:14:09 -0600
Message-ID: <CAP79kiR2bjtihoEFRpcRh9UVyGPJTV6cVD5s7CkGjsOLo-30yg_at_mail.gmail.com>
Assuming you have Diagnostics or Tuning pack you can use this query to get a sample sql_id for each profile you have defined:
select min(sql_id) as sample_sqlid, sql_profile from dba_hist_sqlstat
where sql_profile is not null
group by sql_profile
/
Then you can use dbms_xplan to pass in the sql_ids:
SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('[your sql_id of interest',0));
​Chris
On Fri, Jan 5, 2018 at 1:26 PM, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:
> Can someone tell as how I can check the Execution plan for currently
> enforced SQL profiles ? I had few SQL profile and want to document the
> Execution plan for any comparision at later stage especially after upgrade.
>
> TIA
> Sanjay
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 05 2018 - 22:14:09 CET