Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===============================================================
Oracle 11gR1
DBA_ALERT_HISTORY describes a time-limited history of alerts which are no longer outstanding.
Column
|
Datatype
|
NULL
|
Description
|
SEQUENCE_ID | NUMBER | NOT NULL |
Alert sequence number
|
REASON_ID | NUMBER |
ID of the alert reason
| |
OWNER | VARCHAR2(30) |
Owner of the object on which the alert was issued
| |
OBJECT_NAME | VARCHAR2(513) |
Name of the object
| |
SUBOBJECT_NAME | VARCHAR2(30) |
Name of the subobject
| |
OBJECT_TYPE | VARCHAR2(64) |
Object type
| |
REASON | VARCHAR2(4000) |
Reason for the alert
| |
TIME_SUGGESTED | TIMESTAMP(6) WITH TIME ZONE |
Time when the alert was last updated
| |
CREATION_TIME | TIMESTAMP(6) WITH TIME ZONE |
Time when the alert was first produced
| |
SUGGESTED_ACTION | VARCHAR2(4000) |
Advice of the recommended action
| |
ADVISOR_NAME | VARCHAR2(30) |
Name of the advisor to be invoked for more information
| |
METRIC_VALUE | NUMBER |
Value of the related metrics
| |
MESSAGE_TYPE | VARCHAR2(12) |
Message type:
·
Notification
·
Warning | |
MESSAGE_GROUP | VARCHAR2(64) |
Name of the message group to which the alert belongs
| |
MESSAGE_LEVEL | NUMBER |
Severity message level (1 to 32)
| |
HOSTING_CLIENT_ID | VARCHAR2(64) |
ID of the client or security group to which the alert relates
| |
MODULE_ID | VARCHAR2(64) |
ID of the module that originated the alert
| |
PROCESS_ID | VARCHAR2(128) |
Process ID
| |
HOST_ID | VARCHAR2(256) |
DNS host name of the originating host
| |
HOST_NW_ADDR | VARCHAR2(256) |
IP or other network address of the originating host
| |
INSTANCE_NAME | VARCHAR2(16) |
Originating instance name
| |
INSTANCE_NUMBER | NUMBER |
Originating instance number
| |
USER_ID | VARCHAR2(30) |
User ID
| |
EXECUTION_CONTEXT_ID | VARCHAR2(60) |
ID of the thread of execution
| |
ERROR_INSTANCE_ID | VARCHAR2(142) |
ID of an error instance plus a sequence number
| |
RESOLUTION | VARCHAR2(7) |
Resolution:
·
cleared
·
N/A |
Note:
1.
SELECT REASON_ID, OBJECT_NAME, OBJECT_TYPE, REASON, TIME_SUGGESTED, SUGGESTED_ACTION
FROM DBA_ALERT_HISTORY
ORDER BY TIME_SUGGESTED DESC;
REASON_ID
|
OBJECT_NAME
|
OBJECT_TYPE
|
REASON
|
TIME_SUGGESTED
|
SUGGESTED_ACTION
|
9
|
UNDO
|
TABLESPACE
|
Tablespace [UNDO] is [70 percent] full
|
2008-08-12 3:59:38.061726 AM -07:00
|
Add space to the tablespace
|
9
|
CADASTRE_TABLES
|
TABLESPACE
|
Tablespace [CADASTRE_TABLES] is [74 percent] full
|
2008-08-09 4:07:27.364360 PM -07:00
|
Add space to the tablespace
|
10
|
UNDO
|
TABLESPACE
|
Snapshot Too Old Error detected: SQL ID 9ama6jfu7cpkw, Snapshot SCN 0x08ca.4862a1e4, Recent SCN 0x08ca.4b064c83, Undo Tablespace UNDO, Current Undo Retention 70238.
|
2008-08-06 3:56:20.442627 PM -07:00
|
Please run undo advisor.
|
9
|
UNDO
|
TABLESPACE
|
Tablespace [UNDO] is [83 percent] full
|
2008-08-04 4:12:38.097134 PM -07:00
|
Add space to the 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.
