Oracle教程 2023-02-23

Oracle 视图 ALL_PLSQL_OBJECT_SETTINGS 官方解释，作用，如何使用详细说明

Oracle视图ALL_PLSQL_OBJECT_SETTINGS主要用来获取系统内PL/SQL对象的可选参数设置，这些PL/SQL对象包括函数、存储过程、包和包体。

它的主要用途是帮助我们了解PL/SQL对象的已自定义参数，而不是使用系统默认设置。

使用这个视图需要拥有 DBA权限，可以通过下面的语句来查看带有参数设置的对象：

SELECT name, object_type, parameter_name, parameter_value
FROM all_plsql_object_settings
WHERE name = ‘OBJECT_NAME’;

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

Related Views

DBA_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for all stored objects in the database.
USER_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for the stored objects owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object
`TYPE`	`VARCHAR2(12)`		Type of the object: `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `TRIGGER` `TYPE` `TYPE BODY`
`PLSQL_OPTIMIZE_LEVEL`	`NUMBER`		Optimization level that was used to compile the object
`PLSQL_CODE_TYPE`	`VARCHAR2(4000)`		Compilation mode for the object
`PLSQL_DEBUG`	`VARCHAR2(4000)`		Indicates whether the object was compiled with debug information or not
`PLSQL_WARNINGS`	`VARCHAR2(4000)`		Compiler warning settings that were used to compile the object
`NLS_LENGTH_SEMANTICS`	`VARCHAR2(4000)`		NLS length semantics that were used to compile the object
`PLSQL_CCFLAGS`	`VARCHAR2(4000)`		Conditional compilation flag settings that were used to compile the object
`PLSCOPE_SETTINGS`	`VARCHAR2(4000)`		Settings for using PL/Scope
`ORIGIN_CON_ID`	`NUMBER`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)