Re: ORACLE Session Trace.

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 11 Jan 2005 04:34:52 -0800
Message-ID: <1105446892.029190.69750@f14g2000cwb.googlegroups.com>

yong321_at_yahoo.com wrote:
> Thanks, Srivenu. That's a perfect answer for Dexter's question,
> assuming he's not using 10g which would have dba_enabled_traces (as
> Niall says). Expanding this thread to check whether a non-10046 event
> is set in another session, I posted a message before using event
> errorstack as an example:
>

http://groups-beta.google.com/group/comp.databases.oracle.server/msg/b44fcbcef5a55323
> The number 604 is arbitrarily chosen. The difference between
SQL-trace
> (10046) and others such as errorstack is that in the latter case, the
> trace file is not immediately created. Therefore oradebug
> tracefile_name still does not show a filename in udump, but oradebug
> dump events 1 creates a trace file.

It may not be so perfect if Dexter is running on Windows. I have just checked (because it is a long time since I ran oradebug) and it appears that the trace doesn't get created on windows until the relevant session ends.

In addition I'd be somewhat wary of suggesting that someone use something as powerful as oradebug on a production system. Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Tue Jan 11 2005 - 06:34:52 CST