DBMS_MONITOR
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 22 Dec 2011 22:02:15 +0000 (UTC)
Message-ID: <pan.2011.12.22.22.02.15_at_gmail.com>
It seems that DBMS_MONITOR doesn't operate using the standard event mechanism. When I enabled trace in a session using DBMS_MONITOR, the eventdump didn't show anything. When an explicit "alter session set events" statement was issued, eventdump detected it without problem:
Date: Thu, 22 Dec 2011 22:02:15 +0000 (UTC)
Message-ID: <pan.2011.12.22.22.02.15_at_gmail.com>
It seems that DBMS_MONITOR doesn't operate using the standard event mechanism. When I enabled trace in a session using DBMS_MONITOR, the eventdump didn't show anything. When an explicit "alter session set events" statement was issued, eventdump detected it without problem:
SQL> oradebug setospid 4645
Oracle pid: 30, Unix process pid: 4645, image: oracle_at_medo (TNS V1-V3)
SQL> oradebug eventdump session
sql_trace level=12
SQL>
Question: what mechanism does DBMS_MONITOR use for tracing sessions?
-- http://mgogala.byethost5.comReceived on Thu Dec 22 2011 - 16:02:15 CST