Sanjay, what about running the SQL then getting the dbms_xplan? The plan
should identify that a SQL Profile was used.
If you have access to the AWR (EM Diagnostic Pack License) then perhaps you can
run the $ORACLE_HOME/rdbms/admin/awrsqrpt for each SQL_ID of interest and get
the past used plans.
Mark Powell
Database Administration
(313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
Sent: Friday, January 5, 2018 2:26:07 PM
To: Oracle-L Freelists
Subject: Executuon Plan for SQL profile
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