D Automatic Workload Repository Views for Oracle Exadata System Software

The Automatic Worklad Repository (AWR) views in this appendix are specific to Oracle Exadata System Software. The views are static, because they change only when a change is made to the data dictionary, such as when a new table is created or when a user is granted new privileges. This appendix contains the following views:

D.1 DBA_HIST_ASM_BAD_DISK

The DBA_HIST_ASM_BAD_DISK view displays historic information about non-online Oracle Automatic Storage Management (Oracle ASM) disks. This view contains snapshots of V$ASM_DISK.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

GROUP_NUMBER

NUMBER

NOT NULL

Number of the disk group containing the disk.

NAME

VARCHAR2(128)

NOT NULL

Name of the disk.

PATH

VARCHAR2(256)

Operating system path name portion of the name returned by discovery.

STATUS

VARCHAR2(8)

NOT NULL

Global status for the disk. Only non-online disks are stored in this view.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.2 DBA_HIST_ASM_DISKGROUP

The DBA_HIST_ASM_DISKGROUP view contains information about Oracle ASM disk groups. This retrieves a subset of columns from V$ASM_DISKGROUP.

Column Datatype NULL Description

GROUP_NUMBER

NUMBER

NOT NULL

Cluster-wide number assigned to the disk group.

NAME

VARCHAR2(128)

NOT NULL

Name of the disk group.

TYPE

VARCHAR2(6)

Redundancy type for the disk group.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.3 DBA_HIST_ASM_DISKGROUP_STAT

The DBA_HIST_ASM_DISKGROUP_STAT view displays historic information about Oracle ASM disk groups.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

GROUP_NUMBER

NUMBER

NOT NULL

Cluster-wide number assigned to the disk group.

TOTAL_MB

NUMBER

Total capacity of the disk group in MB.

FREE_MB

NUMBER

Unused capacity in MB of the disk group.

NUM_DISK

NUMBER

Number of disks in the disk group.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.4 DBA_HIST_CELL_CONFIG

The DBA_HIST_CELL_CONFIG view contains information about the configuration of the cells. This data is from V$CELL_CONFIG_INFO.

Column Datatype NULL Description

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELLNAME

VARCHAR2(256)

NOT NULL

Unique identifier for the cell.

CELLHASH

NUMBER

NOT NULL

Hash number to uniquely identify the cell.

CONFTYPE

VARCHAR2(15)

NOT NULL

Configuration type. The configuration type determines the type of information stored in the CONFVAL column.

  • AWRXML: configuration information pertinent to AWR reports.

  • CELL: configuration information about the cell.

  • CELLDISK: configuration information about cell disks.

  • GRIDDISK: configuration information about grid disks.

  • OFFLOAD: configuration information for offload servers.

CONFVAL

CLOB

XML data associated with CONFTYPE.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.5 DBA_HIST_CELL_CONFIG_DETAIL

The DBA_HIST_CELL_CONFIG_DETAIL view displays historic information about the configuration of the cells. This view has the same descriptions as DBA_HIST_CELL_CONFIG, but includes the data for each snapshot, such as a historic view.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELLNAME

VARCHAR2(256)

NOT NULL

Unique identifier for the cell.

CELLHASH

NUMBER

NOT NULL

Hash number to uniquely identify the cell.

CONFTYPE

VARCHAR2(15)

NOT NULL

Configuration type. The configuration type determines the type of information stored in the CONFVAL column.

  • AWRXML: configuration information pertinent to AWR reports.

  • CELL: configuration information for the cell.

  • CELLDISK: configuration information about cell disks.

  • GRIDDISK: configuration information about grid disks.

  • OFFLOAD: configuration information for offload servers.

CONFVAL

CLOB

XML data associated with the CONFTYPE.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.6 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

DBID 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 SRC_DBID.

DISK_BYTES

NUMBER

Number of disk I/O bytes performed by the SRC_DBID.

FLASH_REQUESTS

NUMBER

Number of flash I/O requests performed by the SRC_DBID.

FLASH_BYTES

NUMBER

Number of flash I/O bytes performed by the SRC_DBID.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.7 DBA_HIST_CELL_DISKTYPE

The DBA_HIST_CELL_DISKTYPE view displays historic information about cells, including the types of disks and the capacity of the disks. This view is derived from DBA_HIST_CELL_CONFIG and DBA_HIST_CELL_CONFIG_DETAIL.

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.

CELL_NAME

VARCHAR2(4000)

User-readable cell name.

HARD_DISK_TYPE

VARCHAR2(4000)

The type of hard disk. The format of which is H/size, where size is suffixed by G, or T.

FLASH_DISK_TYPE

VARCHAR2(4000)

The type of flash, the format of which is F/size, where size is suffixed by G, or T.

NUM_CELL_DISKS

NUMBER

Number of cell disks.

NUM_GRID_DISKS

NUMBER

Number of grid disks.

NUM_HARD_DISKS

NUMBER

Number of hard disks.

NUM_FLASH_DISKS

NUMBER

Number of flash disks.

MAX_DISK_IOPS

NUMBER

The maximum number of IOPs for the hard disk type.

MAX_FLASH_IOPS

NUMBER

The maximum number of IOPs for the flash disk type.

MAX_DISK_MBPS

NUMBER

The maximum I/O throughput for the hard disk type, in megabytes per second.

MAX_FLASH_MBPS

NUMBER

The maximum I/O throughput for the flash disk type, in megabytes per second.

MAX_CELL_DISK_IOPS

NUMBER

The maximum number of hard disk IOPs for the cell. This is calculated using MAX_DISK_IOPS*NUM_HARD_DISKS.

MAX_CELL_FLASH_IOPS

NUMBER

The maximum number of flash IOPs for the cell. This is calculated using MAX_FLASH_IOPS*NUM_FLASH_DISKS.

MAX_CELL_DISK_MBPS

NUMBER

The maximum I/O throughput of hard disk for the cell., in megabytes per second. This is calculated using MAX_DISK_MBPS*NUM_HARD_DISKS.

MAX_CELL_FLASH_MBPS

NUMBER

The maximum I/O throughput flash for the cell, in megabytes per second. This is calculated using MAX_FLASH_MBPS*NUM_FLASH_DISKS.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.8 DBA_HIST_CELL_DISK_NAME

The DBA_HIST_CELL_DISK_NAME view displays historic information about disk names on cells. This view is derived from DBA_HIST_CELL_CONFIG and DBA_HIST_CELL_CONFIG_DETAIL.

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.

DISK_ID

NUMBER

NOT NULL

Unique identifier of the disk.

DISK_NAME

VARCHAR2(4000)

User-readable cell name.

DISK

VARCHAR2(4000)

Disk type, either FlashDisk or HardDisk.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.9 DBA_HIST_CELL_DISK_SUMMARY

The DBA_HIST_CELL_DISK_SUMMARY view displays historic information about the performance of disks on cells. For each AWR snapshot, a summary of the per-minute metrics is visible in this view. Each metric stores the sum and the sum of squares, similar to DBA_HIST_SYSMETRIC_SUMMARY. This view is a summary of V$CELL_DISK_HISTORY.

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.

DISK_ID

NUMBER

NOT NULL

Unique identifier of the disk.

NUM_SAMPLES

NUMBER

Number of one-minute samples the summary is based on.

DISK_UTILIZATION_SUM

NUMBER

Sum of the per-minute disk utilization metrics. This is based on OS statistics.

READS_SUM

NUMBER

Sum of the per-minute read requests metrics per second. This is based on OS statistics.

READ_MB_SUM

NUMBER

Sum of the per-minute read metrics, in megabytes per second. This is based on OS statistics.

WRITES_SUM

NUMBER

Sum of the per-minute write requests metrics, per second. This is based on OS statistics.

WRITE_MB_SUM

NUMBER

Sum of the per-minute write metrics, in megabytes per second. This is based on OS statistics.

IO_REQUESTS_SUM

NUMBER

Sum of the per-minute IOPs. This is based on OS statistics.

IO_MB_SUM

NUMBER

Sum of the per-minute I/O metrics, in megabytes per second. This is based on OS statistics.

SERVICE_TIME_SUM

NUMBER

Sum of the per-minute service time metrics. This is based on OS statistics.

WAIT_TIME_SUM

NUMBER

Sum of the per-minute wait time metrics. This is based on OS statistics.

SMALL_READS_SUM

NUMBER

Sum of the per-minute small read requests metrics per second. This is from cell server statistics.

SMALL_WRITES_SUM

NUMBER

Sum of the per-minute small write requests metrics per second. This is from cell server statistics.

LARGE_READS_SUM

NUMBER

Sum of the per-minute large read requests metrics per second. This is from cell server statistics.

LARGE_WRITES_SUM

NUMBER

Sum of the per-minute large write requests metrics per second. This is from cell server statistics.

SMALL_READ_BYTES_SUM

NUMBER

Sum of the per-minute small read bytes metrics per second. This is from cell server statistics.

SMALL_WRITE_BYTES_SUM

NUMBER

Sum of the per-minute small write bytes metrics per second. This is from cell server statistics.

LARGE_READ_BYTES_SUM

NUMBER

Sum of the per-minute large read bytes metrics per second. This is from cell server statistics.

LARGE_WRITE_BYTES_SUM

NUMBER

Sum of the per-minute large write bytes metrics per second. This is from cell server statistics.

SMALL_READ_LATENCY_SUM

NUMBER

Sum of the per-minute small read latency metrics. This data is from cell server statistics.

SMALL_WRITE_LATENCY_SUM

NUMBER

Sum of the per-minute small write latency metrics. This data is from cell server statistics.

LARGE_READ_LATENCY_SUM

NUMBER

Sum of the per-minute large read latency metrics. This data is from cell server statistics.

LARGE_WRITE_LATENCY_SUM

NUMBER

Sum of the per-minute large write latency metrics. This data is from cell server statistics.

APP_IO_REQUESTS_SUM

NUMBER

Sum of the per-minute IOPs metrics. This data is from cell server statistics.

APP_IO_BYTES_SUM

NUMBER

Sum of the per-minute I/O metrics, in megabytes per second. This data is from cell server statistics.

APP_IO_LATENCY_SUM

NUMBER

Sum of the per-minute I/O latency metrics. This data is from cell server statistics.

*_SUMX2

NUMBER

All the previous columns from DISK_UTILIZATION to APP_IO_LATENCY are repeated with the SUMX2 suffix.

This is the sum of squares of the per-minute metrics.

*_AVG

NUMBER

All the previous columns from DISK_UTILIZATION to APP_IO_LATENCY are repeated with the AVG suffix. This is the average of the per-minute metrics.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.10 DBA_HIST_CELL_GLOBAL

The DBA_HIST_CELL_GLOBAL view displays historic information about cell performance statistics. This is a snapshot of V$CELL_GLOBAL.

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 that uniquely identifies the cell.

INCARNATION_NUM

NUMBER

NOT NULL

Incarnation number of the cell.

METRIC_ID

NUMBER

NOT NULL

Metric_id that identifies the metric.

METRIC_NAME

VARCHAR2(257)

Name of the metric.

METRIC_VALUE

NUMBER

The value of the metric.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.11 DBA_HIST_CELL_GLOBAL_SUMMARY

The DBA_HIST_CELL_GLOBAL_SUMMARY view displays historic information about the performance of cells. For each AWR snapshot, a summary of the per-minute metrics is visible in this view. This is a summary of V$CELL_GLOBAL_HISTORY.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot ID

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELL_HASH

NUMBER

NOT NULL

Hash number that uniquely identifies the cell.

INCARNATION_NUM

NUMBER

NOT NULL

Incarnation number of the cell.

NUM_SAMPLES

NUMBER

Number of 1 minute samples the summary is based on.

CPU_USAGE_SUM

NUMBER

Sum of the per-minute CPU usage percentage metrics.

SYS_USAGE_SUM

NUMBER

Sum of the per-minute system CPU usage percentage metrics.

USER_USAGE_SUM

NUMBER

Sum of the per-minute user CPU usage percentage metrics.

NETWORK_BYTES_RECD_SUM

NUMBER

Sum of the per-minute network received metrics, in bytes per second.

NETWORK_BYTES_SENT_SUM

NUMBER

Sum of the per-minute network sent metrics, in bytes per second.

*_SUMX2

NUMBER

All previous columns from CPU_USAGE to NETWORK_BYTES_SENT are repeated with the SUMX2 suffix.

This is the sum of squares of the per-minute metrics.

*_AVG

NUMBER

All previous columns from CPU_USAGE to NETWORK_BYTES_SENT are repeated with the SUMX2 suffix.

This is the average of the per-minute metrics.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.12 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

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELL_HASH

NUMBER

NOT NULL

Hash number that uniquely identifies the cell.

INCARNATION_NUM

NUMBER

NO T NULL

Incarnation number of the cell.

REASON_ID

NUMBER

NOT NULL

Unique identifier for the I/O reason.

REASON_NAME

VARCHAR2(257)

User readable I/O reason.

REQUESTS

NUMBER

Number of I/O requests performed for the reason.

BYTES

NUMBER

Number of IO Bytes performed for the reason.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.13 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.

CONI_D

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.

D.14 DBA_HIST_CELL_METRIC_DESC

The DBA_HIST_CELL_METRIC_DESC view displays information about cell metrics. This data is from V$CELL_METRIC_DESC.

Column Datatype NULL Description

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

METRIC_ID

NUMBER

NOT NULL

Unique identifier for the metric

METRIC_NAME

VARCHAR2(257)

User-readable metric name

METRIC_TYPE

VARCHAR2(17)

NOT NULL

Unit for the metrics, if NULL this is a count.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.15 DBA_HIST_CELL_NAME

The DBA_HIST_CELL_NAME view displays historic information about the names of cells. This view is derived from DBA_HIST_CELL_CONFIG and DBA_HIST_CELL_CONFIG_DETAIL.

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 that uniquely identifies the cell.

CELL_NAME

VARCHAR2(4000)

User-readable cell name.

CON_DBID

NUMBER

The database identifier.

CONI_D

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.

D.16 DBA_HIST_CELL_OPEN_ALERTS

The DBA_HIST_CELL_OPEN_ALERTS view displays the open alerts on cells. Only the 10 most-recent alerts for each cell are stored in AWR. This data is from V$CELL_OPEN_ALERTS.

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 that uniquely identifies the cell.

BEGIN_TIME

DATE

NOT NULL

Time that the alert was opened.

SEQ_NO

NUMBER

NOT NULL

Sequence number of the alert.

MESSAGE

VARCHAR2(1024)

Message describing the alert.

STATEFUL

VARCHAR2(1)

Whether or not the alert has state.

SEVERITY

VARCHAR2(64)

The severity of the alert. Possible values are as follows:

  • critical

  • warning

  • info

CON_DBID

NUMBER

The database identifier.

CONI_D

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.