Re: ORACLE Session Trace.

From: <srivenu_at_hotmail.com>
Date: 10 Jan 2005 05:38:18 -0800
Message-ID: <1105364298.120918.33830@c13g2000cwb.googlegroups.com>

you can use oradebug

example -
Lets say you are running dedicated server and this is the info

Oracle
Background
Sid Ser# ProcessID
------ ------ ------------
162 92 604

Now you want to find out if this session is being traced. SQL> oradebug setospid 604
SQL> oradebug tracefile_name
If trace is on, you will get a tracefile name like this /../../orcl_ora_604.trc

other wise you will just get this output sys> oradebug tracefile_name
Statement processed.
regards
Srivenu Received on Mon Jan 10 2005 - 07:38:18 CST