Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

plsql_debug tips Oracle Tips by Burleson

Oracle plsql_debug

Parameter type – Boolean

Default value – false

Modifiable – ALTER SESSION, ALTER SYSTEM

Range of values – plsql_debug tips=True| plsql_debug tips=False

plsql_debug – This specifies whether or not PL/SQL library units will be compiled for debugging.

Values:

• plsql_debug tips=True – PL/SQL library units will be compiled for debugging.
   

• plsql_debug tips=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 so that they can be debugged.

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.