Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sqltrace for someone else's session?

Re: Sqltrace for someone else's session?

From: itrade2000ca <itrade2000ca_at_yahoo.ca>
Date: Sun, 19 Mar 2000 04:33:30 GMT
Message-ID: <uMYA4.4060$3a.1161463@news2.rdc2.on.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US