Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_SYSTEM.SET_EV does *NOT* list 10046 wait events !

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

From: Spendius <spendius_at_muchomail.com>
Date: 9 Sep 2004 00:51:56 -0700
Message-ID: <aba30b75.0409082351.76bdc58f@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 Received on Thu Sep 09 2004 - 02:51:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US