Re: How to trace a Windows session

William,

Recent past I had the same issue. I tried to trace another session, using
dbms_system.set_ev or set_sql_trace_in_session. I was able to se the trace
successfully, but, there was no trace file generating. When I use, oradebug,
it works.

What I did was, first find out the processid of the session which I want to
trace,

SELECT spid FROM v$session s,v$process p
WHERE v.paddr=p.addr
AND s.sid = &SID

Once you get the processid, set the oradebug

oradebug setospid VALUE (which you got from the above query)

Finally, enable the trace:

oradebug event 10046 trace name context forever, level 12 (any level which
you want)

Once done, turn off the trace

oradebug event 10046 trace name context off;

Jaffar


On 2/27/07, William Wagman <wjwagman@xxxxxxxxxxx> wrote:


Greetings,

I am trying to turn tracing on for another users session in order to
track down some difficulties. The session is coming from a web
application which will allow updates to data within the database. I can
see the users session and the osuser displayed in the v$session view is
NETWORK?SERVICE. I turn on tracing for this session using
dbms_system.set_sql_trace_in_session, the user proceeds, receives an
ORA-00942 but no trace file appears. Quite understand what is going on
and am hoping someone can shed some light on the situation.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
--
http://www.freelists.org/webpage/oracle-l






--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

Other related posts: