DEVFYI - Developer Resource - FYI

What is a database EVENT and how does one set it? (for DBA

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

317. What is a database EVENT and how does one set it? (for DBA

Oracle trace events are useful for debugging the Oracle database server. The following two examples are simply to demonstrate syntax. Refer to later notes on this page for an explanation of what these particular events do.
Either adding them to the INIT.ORA parameter file can activate events. E.g.
event='1401 trace name errorstack, level 12'
... or, by issuing an ALTER SESSION SET EVENTS command: E.g.
alter session set events '10046 trace name context forever, level 4';
The alter session method only affects the user's current session, whereas changes to the INIT.ORA file will affect all sessions once the database has been restarted.

(Continued on next question...)

Other Interview Questions