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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to set event 10046 at level 8 for another session?

Re: How to set event 10046 at level 8 for another session?

From: Jayaraman Ashok <ashok_jayaraman_at_yahoo.com>
Date: 30 Jul 2002 21:02:54 -0700
Message-ID: <7ca2852.0207302002.1a538f9c@posting.google.com>


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

Original text of this message

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