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

Pete Finnigan <plsql_at_petefinnigan.com> wrote in message news:<BBo86KB0CWQBRx2I_at_peterfinnigan.demon.co.uk>...
> >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
> Sorry David you are incorrect about set_ev.
>
> It is possible to set wait and binds to be generated in
> DBMS_SYSTEM.SET_EV. Its the fourth argument of the call. See for example
> my paper
> http://www.petefinnigan.com/ramblings/how_to_set_trace.htm which shows
> many many ways to set trace for your own user and also for other users.
> It also explains levels and how to set them for binds and waits for your
> user or for other users.
>
> Also if you want to use dbms_support its not installed by default on
> some versions and indeed not shipped with some versions. Installing is
> done as follows:
>
> SQL> @%ORACLE_HOME%\rdbms\admin\dbmssupp.sql
>
> Package created.
>
>
> Package body created.
>
> SQL>
>
> Windows example given,
>
> Also DBMS_SUPPORT uses DBMS_SYSTEM.SET_EV, you can see this if you open
> prvtsupp.plb in a text editor and search on set_ev, (pre 10g of course
> as the wrap method has changed in 10g making it not possible to glean
> information from wrapped packages anymore).
>
> Kind regards
>
> Pete

I appreciate all who have pointed to my misinformation and set it straight. I am not a fan of dispensing erroneous answers to posts. Unfortunately in this instance I am the guilty party.

Please accept my apologies.

David Fitzjarrell Received on Fri Sep 10 2004 - 12:14:23 CDT