Sqltrace for someone else's session?

From: <argosy22_at_my-deja.com>
Date: 2000/03/15
Message-ID: <8ap2l9$cae$1@nnrp1.deja.com>#1/1

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 - 00:00:00 CST