RE: How to trace what particular session is doing?
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 03 Mar 2004 09:52:11 +0000
Look into sql_trace or more accurately 10046 trace.
> -----Original Message-----
> From: jaysingh1@xxxxxxxxxxxxx
> Sent: 03 March 2004 02:41
> To: jaysingh1@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
