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: spendius@muchomail.com (Spendius)
Newsgroups: comp.databases.oracle.server
Subject: DBMS_SYSTEM.SET_EV does *NOT* list 10046 wait events !
Date: 9 Sep 2004 00:51:56 -0700
Organization: http://groups.google.com
Lines: 20
Message-ID: <aba30b75.0409082351.76bdc58f@posting.google.com>
NNTP-Posting-Host: 195.177.247.226
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1094716338 575 127.0.0.1 (9 Sep 2004 07:52:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 9 Sep 2004 07:52:18 +0000 (UTC)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224560

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