RE: dbms_support and not getting an explain plan

From: Baumgartel, Paul <>
Date: Mon, 19 May 2008 12:59:18 -0400
Message-ID: <>

In my experience the plan is included in the trace file once the associated cursor is closed. Try issuing a commit or rollback before exiting.  

The other difference between the trace plan and the "explain=" plan is that the former is the actual plan used, unlike the latter.  

You can also look for the plan in v$sql_plan_statistics.  

Paul Baumgartel
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
Phone 212.538.1143  

[] On Behalf Of Rick Ricky Sent: Monday, May 19, 2008 11:24 AM
Subject: dbms_support and not getting an explain plan

I execute


I then run a procedure with a query.
I exit the session to get my last stat line.

I run tkprof sys=no and I do not get an explain plan. If I use the explain= <option> then I get the sqlplus explain plan and not the trace explain plan which has more details (such as LIOs and PIOs for each row source).

anyone else have issues with dbms_support ?

Please access the attached hyperlink for an important electronic communications disclaimer:

Received on Mon May 19 2008 - 11:59:18 CDT

Original text of this message