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.

Note:

1. This parameter was introduced in 11g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘PLSCOPE_SETTINGS’;

Oracle initializatoin parameters