C.2.13 DBA_HIST_CELL_IOREASON
The DBA_HIST_CELL_IOREASON
view displays historic information about the reasons for performing I/Os on the cells. This is a snapshot of V$CELL_IOREASON
.
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. |
|
NUMBER |
NOT NULL |
Incarnation number of the cell. |
|
NUMBER |
NOT NULL |
Unique identifier for the I/O reason. |
|
VARCHAR2(257) |
User readable I/O reason. |
|
|
NUMBER |
Number of I/O requests performed for the reason. |
|
|
NUMBER |
Number of IO Bytes performed for the reason. |
|
|
NUMBER |
The database identifier. |
|
|
NUMBER |
The identifier of the container identified by CON_DBID. Possible values are as follows:
|
|
|
NUMBER |
Number of read requests for the reason. This value includes the flash reads counted in the
|
|
|
NUMBER |
Number of write requests for the reason. This value includes the flash writes counted in the
|
|
|
NUMBER |
Number of flash read requests for the reason. This value is a subset of the value in the
|
|
|
NUMBER |
Number of flash write requests for the reason. This value is a subset of the value in the
|
Parent topic: Automatic Workload Repository Views