RE: how to trace/log a specific session id ??

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Wed, 19 Jul 2000 10:56:35 +0530
Message-Id: <10562.112373@fatcity.com>

u can get the sid and serial# of the app and execute dbms_system.set_sql_trace_in_session(sid, serial#, true)

hth

Babu Nagarajan
Citibank, Mumbai
#653-5042

          _\\|//_
         (' O-O ')

----ooO-(_)-Ooo----

> -----Original Message-----
> From: jim allison [SMTP:jallison01_at_yahoo.com]
> Sent: Tuesday, July 18, 2000 11:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: how to trace/log a specific session id ??

>=20

> Hi friends,

>=20

> I=B4m sure this is piece of cake for many of you, but I
> really need some help.

>=20

> I=B4m in need of tracing (or logging) all SQL commands
> executed on a specific session id. This session is NOT
> a sql plus procedure, it is opened by another
> client/server application. I have no control over it
> BEFORE it starts, and I=B4ll only find out its session
> id after it is already running.

>=20

> I=B4d like to see all SQLs being executed ... no need
> for the actual results of them ...

>=20

> Any tips ??=20

>=20

> Thanks for helping,

>=20

> Jim
> =20

>=20


> __________________________________________________

> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --=20
> Author: jim allison
> INET: jallison01_at_yahoo.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 19 2000 - 00:26:35 CDT