Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: How to trace a Windows session

From: Niall Litchfield <>
Date: Tue, 27 Feb 2007 09:39:11 +0000
Message-ID: <>

I'd expect from your description that you are seeing a web application written using the .net framework, or straight vbscript/asp? If this is the case it's more than likely that you have some sort of connection pooling in place, in which case there is no guarantee at all that the session you see will be the one that gets the error.

I'd say that the appropriate course of action would be

  1. Get the developers to instrument their code. (this can sometimes be achieved you know).
  2. Failing 1 (much more common) I'd be tempted to create a logon trigger to set trace for that particular user. has a number of examples.
  3. 10g and dbms_monitor might be more targetted and useful - though to be honest if the code is written well enough to get the action/module or client info into v$session in the first place the developers are likely to be amenable to approach 1 anyway.

On 2/26/07, William Wagman <> 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
> (530) 754-6208
> --

Niall Litchfield
Oracle DBA

Received on Tue Feb 27 2007 - 03:39:11 CST

Original text of this message