C.2.14 DBA_HIST_CELL_IOREASON_NAME

The DBA_HIST_CELL_IOREASON_NAME view displays the reasons for different I/Os. This data is from V$CELL_IOREASON_NAME.

Column Datatype NULL Description

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

REASON_ID

NUMBER

NOT NULL

Unique identifier for an I/O reason.

REASON_NAME

VARCHAR2(257)

User-readable description of the I/O reason.

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.