SYS.ALL_PLSQL_OBJECT_SETTINGS

The ALL_PLSQL_OBJECT_SETTINGS view displays information about the compiler settings for the stored objects accessible to the current user.

Related views

SYS.DBA_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for all stored objects in the database. It has the same columns as ALL_PLSQL_OBJECT_SETTINGS.
SYS.USER_PLSQL_OBJECT_SETTINGS describes compiler settings for all stored objects that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2 (30) NOT NULL	Object owner.
NAME	VARCHAR2 (30) NOT NULL	Object name.
TYPE	VARCHAR2 (12) NOT NULL	Object type (such as PROCEDURE, FUNCTION).
PLSQL_OPTIMIZE_LEVEL	NUMBER	Optimize level used to compile the object.
PLSQL_CODE_TYPE	VARCHAR2 (4000) NOT INLINE	Compilation mode for the object.
PLSQL_DEBUG	VARCHAR2 (4000) NOT INLINE	Indicates whether the object was compiled with debug information.
PLSQL_WARNINGS	VARCHAR2 (4000) NOT INLINE	Compiler warning settings that were used to compile the object.
NLS_LENGTH_SEMANTICS	VARCHAR2 (4000) NOT INLINE	NLS length semantics that were used to compile the object.
PLSQL_CCFLAGS	VARCHAR2 (4000) NOT INLINE	Conditional compilation flag settings that were used to compile the object.
PLSCOPE_SETTINGS	VARCHAR2 (4000) NOT INLINE	Settings for using PL/Scope.