Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews2.google.com!not-for-mail From: fitzjarrell@cox.net (David Fitzjarrell) Newsgroups: comp.databases.oracle.server Subject: Re: DBMS_SYSTEM.SET_EV does *NOT* list 10046 wait events ! Date: 9 Sep 2004 13:58:18 -0700 Organization: http://groups.google.com Lines: 57 Message-ID: <9711ade0.0409091258.6831ddd4@posting.google.com> References: NNTP-Posting-Host: 68.95.47.225 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1094763498 11461 127.0.0.1 (9 Sep 2004 20:58:18 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 9 Sep 2004 20:58:18 +0000 (UTC) Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224620 spendius@muchomail.com (Spendius) wrote in message news:... > 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 PROCEDURE STOP_TRACE PROCEDURE STOP_TRACE_IN_SESSION Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- SID NUMBER IN SERIAL NUMBER IN SQL> David Fitzajrrell