Sqltrace for someone else's session?

From: <argosy22_at_my-deja.com>
Date: Wed, 15 Mar 2000 22:25:51 GMT
Message-ID: <8ap2l9$cae$1@nnrp1.deja.com>

HI all,

We are using Oracle 7.3.4.
and attempting to figure out what is happening on a database that is accessed via the web.

I have used SQLTRACE to log what is happening with own session. Go into sqlplus and:

alter session
set sql_trace = true

do statements here.

alter session
set sql_trace = false

then look at the .trc file

A remote user's session is hanging, and I am wondering if it is a database issue. Is it possible to set a trace for the user's remote session? How would I do it?

Any other ideas?

Thanks,

Argosy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 16:25:51 CST