The following events are frequently used by DBAs and Oracle Support
to diagnose problems:
" 10046 trace name context forever, level 4 Trace SQL statements and
show bind variables in trace output.
" 10046 trace name context forever, level 8 This shows wait events in
the SQL trace files
" 10046 trace name context forever, level 12 This shows both bind
variable names and wait events in the SQL trace files
" 1401 trace name errorstack, level 12 1401 trace name errorstack,
level 4 1401 trace name processstate Dumps out trace information if
an ORA-1401 "inserted value too large for column" error occurs. The
1401 can be replaced by any other Oracle Server error code that you
want to trace.
" 60 trace name errorstack level 10 Show where in the code Oracle
gets a deadlock (ORA-60), and may help to diagnose the problem.
The following lists of events are examples only. They might be version
specific, so please call Oracle before using them:
" 10210 trace name context forever, level 10 10211 trace name
context forever, level 10 10231 trace name context forever, level 10
These events prevent database block corruptions
" 10049 trace name context forever, level 2 Memory protect cursor
" 10210 trace name context forever, level 2 Data block check
" 10211 trace name context forever, level 2 Index block check
" 10235 trace name context forever, level 1 Memory heap check
" 10262 trace name context forever, level 300 Allow 300 bytes
memory leak for connections
Note: You can use the Unix oerr command to get the description of an
event. On Unix, you can type "oerr ora 10053" from the command
prompt to get event details.