Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to trace a Windows session

Re: How to trace a Windows session

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Tue, 27 Feb 2007 09:29:10 +0300
Message-ID: <97b7fd2f0702262229w75a53f4dl23e2006683acdcb6@mail.gmail.com>


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_at_ucdavis.edu> 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_at_ucdavis.edu
> (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."

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 27 2007 - 00:29:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US