V$ALERT_TYPES

Oracle 11gR1

V$ALERT_TYPES displays information about server alert types.

Column	Datatype	Description
REASON_ID	NUMBER	ID of the alert reason
OBJECT_TYPE	VARCHAR2(64)	Object type
TYPE	VARCHAR2(9)	Alert type: · Stateful · Stateless
GROUP_NAME	VARCHAR2(64)	Group name
SCOPE	VARCHAR2(8)	Scope: · Database · Instance
INTERNAL_METRIC_CATEGORY	VARCHAR2(64)	Internal metric category
INTERNAL_METRIC_NAME	VARCHAR2(64)	Internal metric name

Note:

1.

select * from V$ALERT_TYPES order by reason_id;

REASON_ID	OBJECT_TYPE	TYPE	GROUP_NAME	SCOPE	INTERNAL_METRIC_CATEGORY	INTERNAL_METRIC_NAME
0	SYSTEM	Stateless	Space	Instance	NULL	NULL
1	SYSTEM	Stateful	Space	Instance	NULL	NULL
2	SYSTEM	Stateful	Performance	Instance	instance_efficiency	bufcachehit_pct
3	FILE	Stateful	Performance	Instance	file	read_cs
4	SERVICE	Stateful	Performance	Instance	service	elapsed_cs
5	EVENT_CLASS	Stateful	Performance	Instance	wait_sess_cls	avg_users_waiting_on_class
6	SESSION	Stateful	Performance	Instance	UserBlock	count
7	SYSTEM	Stateless	Performance	Instance	rac_global_cache	corrupt
8	SYSTEM	Stateless	Performance	Instance	rac_global_cache	lost
9	TABLESPACE	Stateful	Space	Database	problemTbsp	pctUsed
10	TABLESPACE	Stateless	Space	Database	Snap_Shot_Too_Old	Tablespace
11	ROLLBACK SEGMENT	Stateless	Space	Database	Snap_Shot_Too_Old	Rollback_Segment
12	TABLESPACE	Stateful	Space	Database	Suspended_Session	Tablespace
……

2. The following dictionary views provide information about server alerts:

• DBA_THRESHOLDS lists the threshold settings defined for the instance.
• DBA_OUTSTANDING_ALERTS describes the outstanding alerts in the database.
• DBA_ALERT_HISTORY lists a history of alerts that have been cleared.
• V$ALERT_TYPES provides information such as group and type for each alert.
• V$METRICNAME contains the names, identifiers, and other information about the system metrics.
• V$METRIC and V$METRIC_HISTORY views contain system-level metric values in memory.

Oracle dynamic performance views