C.2.17 DBA_HIST_CELL_OPEN_ALERTS
The DBA_HIST_CELL_OPEN_ALERTS
view displays the open alerts on cells. Only the 10 most-recent alerts for each cell are stored in AWR. This data is from V$CELL_OPEN_ALERTS
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number that uniquely identifies the cell. |
|
DATE |
NOT NULL |
Time that the alert was opened. |
|
NUMBER |
NOT NULL |
Sequence number of the alert. |
|
VARCHAR2(1024) |
Message describing the alert. |
|
|
VARCHAR2(1) |
Whether or not the alert has state. |
|
|
VARCHAR2(64) |
The severity of the alert. Possible values are as follows:
|
|
|
NUMBER |
The database identifier. |
|
|
NUMBER |
The identifier of the container identified by CON_DBID. Possible values are as follows:
|
Parent topic: Automatic Workload Repository Views