Home » RDBMS Server » Server Administration » How to discover what system events have been set
How to discover what system events have been set [message #51177] Mon, 06 May 2002 07:15 Go to next message
Rich Stucke
Messages: 2
Registered: May 2002
Junior Member
I am a DBA supporting an Oracle 8.1.7 database, and I wanted to know if anyone knows of a query or what system table(s) or view(s) contains the information about the system events that have been set??

Report message to a moderator

Re: How to discover what system events have been set [message #51180 is a reply to message #51177] Mon, 06 May 2002 07:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
V_$EVENT_NAME

Report message to a moderator

Re: How to discover what system events have been set [message #51197 is a reply to message #51180] Mon, 06 May 2002 13:29 Go to previous message
Rich Stucke
Messages: 2
Registered: May 2002
Junior Member
v$event_name along with all of the other sys.views only pertain to wait events. I'm talking about system events i.e. ( ALTER SESSION SET EVENTS '10015 TRACE NAME CONTEXT FOREVER, LEVEL 3'; or ALTER SESSION SET SQL_TRACE = TRUE; )

Report message to a moderator

Previous Topic: Data Dictionary view to locate paramater file
Next Topic: logging and rollback segs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 09 18:49:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.