Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to set event 10046 at level 8 for another session?
Thanks.....
Ashok
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3D46D00F.2E0A_at_yahoo.com>...
> Jayaraman Ashok wrote:
> >
> > Hi
> > Is it possible to trace another session by setting the 10046 event at
> > level 8? Can it be done using dbms_system.set_int_param_in_session() ?
> > Kindly help me in this regard as i would like to know waits and bind
> > variable values for the other session.
> >
> > Cheers,
> > Ashok
>
> sys.dbms_system.set_sql_trace_in_session
>
> or if you need a higher level, dbms_system.set_ev
>
> hth
> connor
Received on Tue Jul 30 2002 - 23:02:54 CDT