dbms_support and not getting an explain plan
- From: "Rick Ricky" <ricks12345@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 May 2008 11:23:44 -0400
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 ?
Other related posts:
