RE: dbms_support and not getting an explain plan
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-lReceived on Mon May 19 2008 - 11:59:18 CDT