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.