dbms_support and not getting an explain plan

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Mon, 19 May 2008 11:23:44 -0400
Message-ID: <81f4c0700805190823x4eb43f4ch3e817f6773cfd1f5@mail.gmail.com>


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 ?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 19 2008 - 10:23:44 CDT

Original text of this message