RE: dbms_support and not getting an explain plan

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.  

Regards,
Brandon  

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.

--
http://www.freelists.org/webpage/oracle-l