| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to determine what events are set
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Tuesday, December 07, 2004 11:55 AM
To: DEEDSD_at_nationwide.com
Cc: oracle-l_at_freelists.org
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_at_nationwide.com
<DEEDSD_at_nationwide.com> 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
--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 07 2004 - 12:29:21 CST
 |
 |