Re: Executuon Plan for SQL profile

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-l