RE: how to determine what events are set

  • From: "Post, Ethan" <Ethan.Post@xxxxxx>
  • To: <jkstill@xxxxxxxxx>, <DEEDSD@xxxxxxxxxxxxxx>
  • Date: Tue, 7 Dec 2004 12:17:41 -0600

DEEDSD might just be looking for V$PARAMETER, or just use "show
parameter event", if DEEDSD is looking for events at the session level I
would want to know more about why they are concerned about this (not
that there are not valid reasons) but this is not typically the type of
thing most people look for.

show parameter event

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
event                                string      6508 trace name
errorstack lev
                                                 el 12, 6503 trace name
errorst
                                                 ack level 12, 6502
trace name
                                                 errorstack level 12,
1401 trac
                                                 e name errorstack level
12, 15
                                                 55 trace name
errorstack level
                                                  12, 30554 trace name
errorsta
                                                 ck level 12, 24372
trace name
                                                 errorstack level 12,
4092 trac
                                                 e name errorstack level
12, 40
                                                 30 trace name
errorstack level
                                                  12, 4031 trace name
errorstac
                                                 k level 12, 2291 trace
name er
                                                 rorstack level 12, 1722
trace
                                                 name errorstack level
12, 1017
                                                  trace name errorstack
level 1
                                                 2, 1002 trace name
errorstack
                                                 le
=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Tuesday, December 07, 2004 11:55 AM
To: DEEDSD@xxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: how to determine what events are set

google for 'dbms_system.read_ev'



On Tue, 7 Dec 2004 11:39:52 -0500, DEEDSD@xxxxxxxxxxxxxx
<DEEDSD@xxxxxxxxxxxxxx> wrote:
> I think this was answered before on this list (or I heard it in a
class)
> but I can't seem to find it.  I recall there being a table that can be
> queried to determine which events are set in the database, for a
session,
> etc.  I can't remember what the name is, though.  Anyone remember?
>=20
> --
> //www.freelists.org/webpage/oracle-l
>=20


--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: