Re: Level 12 Trace

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 25 Mar 2004 18:12:48 +0100
Message-ID: <406312dd$0$11592$636a15ce@news.free.fr>

"Tim Smith" <timasmith_at_hotmail.com> a écrit dans le message de news:a7234bb1.0403250748.afabe2a_at_posting.google.com...
> Disclaimer: We are in the process of upgrading our Oracle database.
>
>
> We are doing some performance tuning and I need to trigger the 10046
> event with level 12 tracing. I read somewhere that it can be done
> through the dbms_support package, but the procedure in question is not
> available in 8.0.5.
>
> Is there any way I can alter a session to do level 12 tracing,
> trace_sql_in_session does level.
>
> I can do it adding to the init.ora but that is a little intrusive.

I don't know what is available in 8.0.5 but have a look at Pete Finnigan paper: http://www.petefinnigan.com/ramblings/how_to_set_trace.htm

Regards
Michel Cadot Received on Thu Mar 25 2004 - 11:12:48 CST