C.2.7 DBA_HIST_CELL_DB
The DBA_HIST_CELL_DB
view displays historic information about the databases consuming resources on the cells. Only the top 10 databases are stored in each AWR snapshot. This is a snapshot of V$CELL_DB
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number to uniquely identify the cell. |
|
NUMBER |
NOT NULL |
Incarnation number of the cell. Each cell reboot will increment the incarnation number. |
|
NUMBER |
NOT NULL |
Database identifier performing the I/Os. |
|
VARCHAR2(256) |
DB Name performing the I/Os. |
|
|
NUMBER |
Number of disk I/O requests performed by the database. |
|
|
NUMBER |
Number of disk I/O bytes processed by the database. |
|
|
NUMBER |
Number of flash I/O requests performed by the database. |
|
|
NUMBER |
Number of flash I/O bytes processed by the database. |
|
|
NUMBER |
Number of small IO requests issued to disks by the database. Parallel cell metric: |
|
|
NUMBER |
Number of large IO requests issued to disks by the database. Parallel cell metric: |
|
|
NUMBER |
Number of small IO requests issued to flash by the database. Parallel cell metric: |
|
|
NUMBER |
Number of large IO requests issued to flash by the database. Parallel cell metric: |
|
|
NUMBER |
The latency (in nanoseconds) of small IO requests issued to disks by the database. Parallel cell metric: |
|
|
NUMBER |
The IORM wait time (in nanoseconds) for small IO requests issued to disks by the database. Parallel cell metric: |
|
|
NUMBER |
The latency (in nanoseconds) of large IO requests issued to disks by the database. Parallel cell metric: |
|
|
NUMBER |
The IORM wait time (in nanoseconds) for large IO requests issued to disks by the database. Parallel cell metric: |
|
|
NUMBER |
The latency (in nanoseconds) of small IO requests issued to flash by the database. Parallel cell metric: |
|
|
NUMBER |
The IORM wait time (in nanoseconds) for small IO requests issued to flash by the database. Parallel cell metric: |
|
|
NUMBER |
The latency (in nanoseconds) of large IO requests issued to flash by the database. Parallel cell metric: |
|
|
NUMBER |
The IORM wait time (in nanoseconds) for large IO requests issued to flash by the database. Parallel cell metric: |
|
|
NUMBER |
Value is |
|
|
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