Look into sql_trace or more accurately 10046 trace.

> -----Original Message-----
> From: jaysingh1@(protected)
> Sent: 03 March 2004 02:41
> To: jaysingh1@(protected)
> Subject: How to trace what particular session is doing?
>
>
> Dear All,
>
> I like to trace what particular session is doing at given
> point in time? I
> know something i have to join
> v$session,v$process,v$transaction and v$sql but somehow not
> able to get
> succeed.
>
> Does anyone have a script for the same?
>
> Thanks
> Jay
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>



**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------