Re: problem consistently getting explain plan with 10046 trace

maybe before you do context off, just do "select 1 from dual;"

the plans are dumped to trace file after the cursor is closed, which is what happens when you exit the session. If you don't want to, just select something from dual.

Raj

On 8/4/06, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
>
>
> 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.
>

-- 
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l