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@xxxxxxxxxxxxx>
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
