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
SNAP_ID	NUMBER	NOT NULL	Unique snapshot identifier.
DBID	NUMBER	NOT NULL	Database identifier for the snapshot.
CELL_HASH	NUMBER	NOT NULL	Hash number to uniquely identify the cell.
INCARNATION_NUM	NUMBER	NOT NULL	Incarnation number of the cell. Each cell reboot will increment the incarnation number.
SRC_DBID	NUMBER	NOT NULL	Database identifier performing the I/Os.
SRC_DBNAME	VARCHAR2(256)		DB Name performing the I/Os.
DISK_REQUESTS	NUMBER		Number of disk I/O requests performed by the database.
DISK_BYTES	NUMBER		Number of disk I/O bytes processed by the database.
FLASH_REQUESTS	NUMBER		Number of flash I/O requests performed by the database.
FLASH_BYTES	NUMBER		Number of flash I/O bytes processed by the database.
DISK_SMALL_IO_REQS	NUMBER		Number of small IO requests issued to disks by the database. Parallel cell metric: DB_IO_RQ_SM
DISK_LARGE_IO_REQS	NUMBER		Number of large IO requests issued to disks by the database. Parallel cell metric: DB_IO_RQ_LG
FLASH_SMALL_IO_REQS	NUMBER		Number of small IO requests issued to flash by the database. Parallel cell metric: DB_FD_IO_RQ_SM
FLASH_LARGE_IO_REQS	NUMBER		Number of large IO requests issued to flash by the database. Parallel cell metric: DB_FD_IO_RQ_LG
DISK_SMALL_IO_SERVICE_TIME	NUMBER		The latency (in nanoseconds) of small IO requests issued to disks by the database. Parallel cell metric: DB_IO_TM_SM
DISK_SMALL_IO_QUEUE_TIME	NUMBER		The IORM wait time (in nanoseconds) for small IO requests issued to disks by the database. Parallel cell metric: DB_IO_WT_SM
DISK_LARGE_IO_SERVICE_TIME	NUMBER		The latency (in nanoseconds) of large IO requests issued to disks by the database. Parallel cell metric: DB_IO_TM_LG
DISK_LARGE_IO_QUEUE_TIME	NUMBER		The IORM wait time (in nanoseconds) for large IO requests issued to disks by the database. Parallel cell metric: DB_IO_WT_LG
FLASH_SMALL_IO_SERVICE_TIME	NUMBER		The latency (in nanoseconds) of small IO requests issued to flash by the database. Parallel cell metric: DB_FD_IO_TM_SM
FLASH_SMALL_IO_QUEUE_TIME	NUMBER		The IORM wait time (in nanoseconds) for small IO requests issued to flash by the database. Parallel cell metric: DB_FD_IO_WT_SM
FLASH_LARGE_IO_SERVICE_TIME	NUMBER		The latency (in nanoseconds) of large IO requests issued to flash by the database. Parallel cell metric: DB_FD_IO_TM_LG
FLASH_LARGE_IO_QUEUE_TIME	NUMBER		The IORM wait time (in nanoseconds) for large IO requests issued to flash by the database. Parallel cell metric: DB_FD_IO_WT_LG
IS_CURRENT_SRC_DB	NUMBER		Value is 1 for the database that captured the AWR data. Otherwise, value is NULL.
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.