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

It appears I forgot to mention how to install dbms_support if it isn't already:

SQL> connect / as sysdba
Connected.
SQL> @?/rdbms/admin/dbmssupp

Package created.

Package body created.

SQL> desc dbms_support
FUNCTION MYSID RETURNS NUMBER
FUNCTION PACKAGE_VERSION RETURNS VARCHAR2 PROCEDURE START_TRACE

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT
PROCEDURE START_TRACE_IN_SESSION
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN

SQL> David Fitzajrrell Received on Thu Sep 09 2004 - 15:58:18 CDT