One of the fields in this view, SUGGESTED_ACTION,
contains a recommendation for addressing the alert condition.
DBA_ALERT_HISTORY
After an alert in DBA_OUTSTANDING_ALERTS has been addressed and cleared, a record of the
cleared alert is available in the view DBA_ALERT_HISTORY.
V$ALERT_TYPES
The dynamic performance view V$ALERT_TYPES (new to Oracle 10g) lists the 158 alert conditions
(as of Oracle 11g, Release 1) that can be monitored. The GROUP_NAME column categorizes the
alert conditions by type. For example, for space management issues, we would use alerts with a
GROUP_NAME of 'Space':
SQL> select reason_id, object_type, scope, internal_metric_category,
2 internal_metric_name from v$alert_types
3 where group_name = 'Space';
REASON_ID OBJECT_TYPE SCOPE INTERNAL_METRIC_CATE INTERNAL_METRIC_NA
---------- ------------------ -------- -------------------- ------------------
123 RECOVERY AREA Database Recovery_Area Free_Space
1 SYSTEM Instance
0 SYSTEM Instance
?–
?–
?–
?–
?–
?–
?–
?–
?–
Chapter 6: Monitoring Space Usage 175
133 TABLESPACE Database problemTbsp bytesFree
9 TABLESPACE Database problemTbsp pctUsed
12 TABLESPACE Database Suspended_Session Tablespace
10 TABLESPACE Database Snap_Shot_Too_Old Tablespace
13 ROLLBACK SEGMENT Database Suspended_Session Rollback_Segment
11 ROLLBACK SEGMENT Database Snap_Shot_Too_Old Rollback_Segment
14 DATA OBJECT Database Suspended_Session Data_Object
15 QUOTA Database Suspended_Session Quota
11 rows selected.
Pages:
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318