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

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELL_HASH

NUMBER

NOT NULL

Hash number that uniquely identifies the cell.

BEGIN_TIME

DATE

NOT NULL

Time that the alert was opened.

SEQ_NO

NUMBER

NOT NULL

Sequence number of the alert.

MESSAGE

VARCHAR2(1024)

Message describing the alert.

STATEFUL

VARCHAR2(1)

Whether or not the alert has state.

SEVERITY

VARCHAR2(64)

The severity of the alert. Possible values are as follows:

  • critical

  • warning

  • info

CON_DBID

NUMBER

The database identifier.

CON_ID

NUMBER

The identifier of the container identified by CON_DBID. Possible values are as follows:

  • 0: This value is used for non-container database (CDB).

  • 1: This value is used for the root container of the CDB.

Parent topic: Automatic Workload Repository Views