Re: showing set events

From: sybrandb@xxxxxxxxx
Date: Thu, 29 Nov 2007 22:57:22 +0100

On Thu, 29 Nov 2007 09:06:50 -0800 (PST), "oracle_man@xxxxxxxxx"
<rheadrick@xxxxxxxxxxxxxxxxx> wrote:

Anyone know how to tell if an event is currently set such as "ALTER
SYSTEM SET EVENTS '1652 trace name errorstack';" ?

Show parameter does not tell me.

Daniel, it was good to see you at NOCOUG. Sorry I didn't get a chance
to say hi.

--Rich

use dbms_system.read_ev

--
Sybrand Bakker
Senior Oracle DBA
.

Follow-Ups:
- Re: showing set events
  - From: DA Morgan

References:
- showing set events
  - From: oracle_man@xxxxxxxxx

Prev by Date: Tips for migration of Records Scaling to 200 Million Rows
Next by Date: Re: utl_smtp Hanging when opening a connection
Previous by thread: Re: showing set events
Next by thread: Re: showing set events
Index(es):
- Date
- Thread

Relevant Pages

Re: Forms 9.0.4.2 Problem
... the logs or doing a trace on the session. ... execute immediate 'alter session set events="4062 dump errorstack ... (working examples showing how to dump the errorstack on Metalink. ...
(comp.databases.oracle.server)
Re: showing set events
... SYSTEM SET EVENTS '1652 trace name errorstack';"? ... Daniel, it was good to see you at NOCOUG. ... Puget Sound Oracle Users Group ...
(comp.databases.oracle.server)
Re: showing set events
... SYSTEM SET EVENTS '1652 trace name errorstack';"? ... Daniel, it was good to see you at NOCOUG. ... Puget Sound Oracle Users Group ...
(comp.databases.oracle.server)
Re: Solved: ::errorStack in pure Tcl (was Re: Substed ::errorInfo)
... set::errorStack ... the error context options (like the errorInfo trace itself and other ...
(comp.lang.tcl)
Re: ORA-00937 when CURSOR_SHARING=FORCE
... to set trace for the complete instance. ... You could also dump the errorstack for error 937 (to see the exact ... alter system set events="937 trace name errorstack, ... execute immediate 'alter session set sql_trace=true' run automatically. ...
(comp.databases.oracle.server)