What database events can be set? (for DBA
ORACLE Interview Questions and Answers (Part 2)
(Continued from previous question...)
319. What database events can be set? (for DBA
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.
(Continued on next question...)
Other Interview Questions
|