Thanks Chris. This is what i am looking.
RgdsSanjay
On Friday, January 5, 2018 4:15 PM, Chris Taylor
<christopherdtaylor1994@xxxxxxxxx> wrote:
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_sqlstatwhere
sql_profile is not nullgroup 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.
TIASanjay
