Re: Executuon Plan for SQL profile
Date: Sat, 6 Jan 2018 00:20:59 +0000 (UTC)
Message-ID: <29330436.1303008.1515198059360_at_mail.yahoo.com>
Thanks Chris. This is what i am looking. RgdsSanjay
On Friday, January 5, 2018 4:15 PM, Chris Taylor <christopherdtaylor1994_at_gmail.com> 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_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. TIASanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 06 2018 - 01:20:59 CET