Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> problem consistently getting explain plan with 10046 trace

problem consistently getting explain plan with 10046 trace

From: <ryan_gaffuri_at_comcast.net>
Date: Fri, 04 Aug 2006 15:20:02 +0000
Message-Id: <080420061520.26525.44D365A20009D4A80000679D2207024553079D9A00000E09A1020E979D@comcast.net>


We have found that we do not always get the 10046 explain plan that gives us the LIO and PIO for each row source with a level 12 report.

This is what we are doing.

alter session set time_statistics=true
alter session set events '10046 trace name context forever, level 12'; <run stuff>
alter session set events '10046 trace name context off';

We find that we get the plan more often if we do a level 8 and if we exit the session the session before running tkprof.

tkprof *.trc *.rep sys=no explain=<username/password>

I don't really want the 'explain plan' you get in sqlplus. I need the one specific to the trace file that gives LIOs and PIOs by row source.

anyone else having this problem?

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 04 2006 - 10:20:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US