Property | Description |
Parameter type | String |
Syntax |
|
Default value |
|
Modifiable |
|
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’;
No comments:
Post a Comment