Re: DBMS_SYSTEM.SET_EV does *NOT* list 10046 wait events !

spendius_at_muchomail.com (Spendius) wrote in message news:<aba30b75.0409082351.76bdc58f_at_posting.google.com>...
> Hi,
> When I use
> >alter session set events '10046 trace name context forever,
> >level &&1'
> on my own session OK I get everything I want in my trace file, but
> when I try to trace ANOTHER session using the proc.
> >exec sys.dbms_system.set_ev(&sid, &serial, 10046, &1, '')
>
> I *never* find the paragraphs stating the waits endured by this
> session:
> >Elapsed times include waiting on following events:
> > Event waited on Times Max. Wait Total Waited
> > ------------------------------ Waited ---------- ------------
> > library cache lock 73 3.02 298.37
> > library cache load lock 1 0.22 0.22
> > SQL*Net message to client 1 0.00 0.00
>
> Gaat het goed in uw winkel ?
> Thanks.
> Spendius

And you won't, not with dbme_system.set_ev. There is no way for you to specify you want wait information. You should be using dbms_support.start_trace_in_session. With that procedure you CAN specify you want wait information; you can also trace binds:

exec sys.dbms_support.start_trace_in_session(&sid, &serial, waits=>true, binds=>false);

Use this and you'll see your wait stats.

David Fitzjarrell Received on Thu Sep 09 2004 - 15:45:50 CDT