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.
Profiling large applications may produce a large volume of data. You can control the volume of data collected by enabling specific program units for trace data collection.
You can enable a program unit by compiling it debug. This can be done in one of two ways:
ALTER SESSION SET plsql_debug=TRUE;
CREATE OR REPLACE … /* create the library units – debug information will be generated */
or:
/* recompile specific library unit with debug option */
alter [PROCEDURE | FUNCTION | PACKAGE BODY] compile debug;
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_trace.htm#BABEGCDD
D