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 CREDIT SUISSE Information Technology Prime Services Databases Americas One Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rick Ricky Sent: Monday, May 19, 2008 11:24 AM To: oracle-l@xxxxxxxxxxxxx Subject: dbms_support and not getting an explain plan I execute sys.dbms_support.start_trace(true,true); 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: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==============================================================================