Understand events of oracle
Posted on May 8, 2008
Four Event Categories
1. Dump diagnostic information on request
2. Dump diagnostic information when an error
occurs
3. Change database behavior
4. Produce trace diagnostics as the database runs
Immediate Dump Events
Immediate dump events dump diagnostic information to a trace file. Common
immediate dumps are:
• File headers (control file, redo log files, data files)
• System state dumps
• Process state dumps
On-Error Dump Events
On-error dumps are similar to immediate dumps; however, they are only produced
when errors occur. The most common one is the error stack, which produces a dump
of the process call stack at the time of failure and can also dump other information.
Refer to <Note:37871.1> [http://webiv.oraclecorp.com/cgibin/
webiv/do.pl/Get?WwwID=note:37871.1] for more information on the on-error
dumps.
Change Behavior Events
With this event category, you can change the Oracle server’s behavior, enable hidden
features, work around problems, and perform specialized tuning.
Trace Events
Copyright © Oracle Corporation, 2001. All rights reserved.
Diagnostic Events
Chapter 2 – Page 6
Trace events produce a diagnostic trace as processes are running. You can use trace
events to gather additional information so that a problem can be understood and
resolved.
Popularity: 1% [?]
Related Posts:
» Filed Under Other
Comments
Leave a Reply