Friday, November 14, 2008

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

No comments:

Post a Comment