RE: dbms_support and not getting an explain plan

From: Allen, Brandon <>
Date: Mon, 19 May 2008 11:00:38 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450BA65CA1@NT15.oneneck.corp>

Yes, but the OP said he's exiting the session so that will take care of closing the cursors.  

Good point about getting the plan from v$sql_plan_stastistics (or just v$sql_plan) though - just have to be careful that the plan used at the time of your tracing could be different from the version currently in the shared pool.  

In case you're not familiar with getting plans out of v$sql_plan and it's associated views, you'll want to look up dbms_xplan.display_cursor.  


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Mon May 19 2008 - 13:00:38 CDT

Original text of this message