Re: Executuon Plan for SQL profile
From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Fri, 5 Jan 2018 20:09:54 +0000
Message-ID: <DF4PR8401MB127665EBCC02C548E3786E96CC1C0_at_DF4PR8401MB1276.NAMPRD84.PROD.OUTLOOK.COM>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: Friday, January 5, 2018 2:26:07 PM To: Oracle-L Freelists
Subject: Executuon Plan for SQL profile
Date: Fri, 5 Jan 2018 20:09:54 +0000
Message-ID: <DF4PR8401MB127665EBCC02C548E3786E96CC1C0_at_DF4PR8401MB1276.NAMPRD84.PROD.OUTLOOK.COM>
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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 05 2018 - 21:09:54 CET