RE: dbms_support and not getting an explain plan

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Mon, 19 May 2008 12:59:18 -0400
Message-ID: <21469B88E0EA11498818517F210335310455AE7E@EPRI17P32001A.csfb.cs-group.com>


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_at_credit-suisse.com
www.credit-suisse.com  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rick Ricky Sent: Monday, May 19, 2008 11:24 AM
To: oracle-l_at_freelists.org
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


--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 19 2008 - 11:59:18 CDT

Original text of this message