DBA_WARNING_SETTINGS

DBA_WARNING_SETTINGS displays information about the warning parameter settings for all objects in the database. Its columns are the same as those in ALL_WARNING_SETTINGS.

Related Views

· ALL_WARNING_SETTINGS displays information about the warning parameter settings for the objects accessible to the current user.

· USER_WARNING_SETTINGS displays information about the warning parameter settings for the objects owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Name of the object
OBJECT_ID	NUMBER	NOT NULL	Object number of the object
OBJECT_TYPE	VARCHAR2(12)		Type of the object: · PROCEDURE · FUNCTION · PACKAGE · PACKAGE BODY · TRIGGER · TYPE · TYPE BODY
WARNING	VARCHAR2(40)		Warning number or category: · INFORMATIONAL · PERFORMANCE · SEVERE · ALL
SETTING	VARCHAR2(7)		Value of the warning setting: · DISABLE · ENABLE · ERROR

Note:

1.

select * from DBA_WARNING_SETTINGS where owner = 'SDE';

OWNER	OBJECT_NAME	OBJECT_ID	OBJECT_TYPE	WARNING	SETTING
SDE	DBTUNE_UTIL	72979	PACKAGE	ALL	DISABLE
SDE	DBTUNE_UTIL	73001	PACKAGE BODY	ALL	DISABLE
SDE	GDB_AR_TR	1027846	TRIGGER	ALL	DISABLE

Oracle data dictionary views

Oracle dynamic performance views