Which statement is true about the effect of the command?

You execute the following command in the user session:
SQL> ALTER SESSION SET PLSQL_DEBUG=true;
Which statement is true about the effect of the command?

You execute the following command in the user session:
SQL> ALTER SESSION SET PLSQL_DEBUG=true;
Which statement is true about the effect of the command?

A.
All PL/SQL blocks that are executed subsequently in the session are traced.

B.
It enables all PL/SQL blocks that are compiled subsequently in the session for tracing.

C.
Only anonymous PL/SQL blocks that are executed subsequently in the session are traced.

D.
It enables only named PL/SQL blocks that are executed subsequently in the session for
tracing.

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

ja

ja

B.

http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams181.htm#REFRN10254

PLSQL_DEBUG specifies whether or not PL/SQL library units will be compiled for debugging.

Values:

true

PL/SQL library units will be compiled for debugging

false

PL/SQL library units will be compiled for normal execution

When PLSQL_DEBUG is set to true, PL/SQL library units are always compiled INTERPRETED in order to be debuggable.

When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. The value of this parameter is stored persistently with each library unit.

Reply

Leo Yu

Leo Yu

Thanks JA for your quotation, noticed that” alway compiled INTERPRETED in order to be debuggable” could be one exam point

Reply