The following command is executed to start tracing in a user session:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS);
Which statement is true about the effect of the command?
A.
It allows tracing of exceptions raised by all subprograms executed in the session.
B.
It allows tracing of user-defined exceptions raised by all subprograms executed in the session.
C.
It allows tracing of system-defined exceptions raised by all subprograms executed in the session.
D.
It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.
D.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_trace.htm#i1002289
Tracing Exceptions
Two levels of exception tracing are available:
Level 1: Trace all exceptions. This corresponds to TRACE_ALL_EXCEPTIONS.
Level 2: Trace exceptions raised in enabled program units only. This corresponds to TRACE_ENABLED_EXCEPTIONS.
help. What does “exception raised in enabled program units only”? I suppose the program unit has already been enabled to trace exception after performing “ALTER FUNCTION my_function COMPILE DEBUG”
D TRACE_ENABLED_EXCEPTIONS:Traces exceptions and handlers
exception and exception handlers