RE: dbms_support and not getting an explain plan
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: ricks12345@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 May 2008 12:59:18 -0400
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
==============================================================================
Other related posts:
