Re: Sqltrace for someone else's session?

dbms_session is Oracle 8i function. In 7.3.4, it should use dbms_system.set_sql_Trace_in_sesion(sid, serial#,[TRUE|FALSE])

If a remote user was hanging, it won't be your session Argosy's session problem. If it keeps happen, it may be a bug. You should call Oracle support and report this report.

<miaemp_at_my-deja.com> wrote in message news:8ap3k1$csn$1_at_nnrp1.deja.com...
> Yes you can. you need to do the following, get the user's SID and
> SERIAL# from v$session. Then to set the trace run the following:
> execute dbms_session.set_sql_trace_in_session([SID],[SERIAL#],[TRUE |
> FALSE])
>
> I have done this many times myself.
>
> HTH
> Eric Peterson
>
> In article <8ap2l9$cae$1_at_nnrp1.deja.com>,
> argosy22_at_my-deja.com wrote:
> >
> >
> > 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.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Mar 18 2000 - 22:33:30 CST