PLSCOPE_SETTINGS

Property Description
Parameter type String
Syntax PLSCOPE_SETTINGS = IDENTIFIERS:{ NONE | ALL }
Default value IDENTIFIERS:NONE
Modifiable ALTER SESSION, ALTER SYSTEM
Basic No

PLSCOPE_SETTINGS controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data.

Values:

  • IDENTIFIERS:NONE

    Disables collection of identifier data. This is the default.

  • IDENTIFIERS:ALL

    Enables the collection of all source code identifier data.

PLSCOPE_SETTINGS can be set on a session, system, or per-library unit (ALTER COMPILE) basis. The current setting of PLSCOPE_SETTINGS for any library unit can be attained by querying the *_PLSQL_OBJECT_SETTINGS views. Any identifier data collected by setting this parameter can be accessed using the *_IDENTIFIERS views.