C Exadata-Specific Information in Oracle Database Dictionary Views

C.1 Oracle Database Dictionary Views

The Oracle Database dictionary contains views that are specific to Oracle Exadata Database Machine.

C.1.1 Using the V$CELL and GV$CELL Views to Display Oracle Exadata Storage Server Identification

The V$CELL view provides identifying information about cells.

Table C-1 V$CELL View Columns and Descriptions

Column Description

CELL_HASHVAL

A numeric hash value for the cell. For example:

138889696

Note: The cell hash value is often contained in the P1 argument for cell-related wait events in the V$SESSION_WAIT and V$ACTIVE_SESSION_HISTORY views. You can join to this column to identify the corresponding cell.

CELL_PATH

A character string (maximum 400) that specifies the IP addresses of the cell. These are the IP addresses specified in the cellip.ora file.

CELL_TYPE

The type of storage cell. Either EXADATA or BDSQL.

The GV$CELL view contains the same columns as the V$CELL view, and includes the INST_ID column. The INST_ID column displays the instance number from which the associated V$ view information was obtained. Querying a GV$ view retrieves the V$ view information from all qualified instances.

C.1.2 About the V$CELL_ Views

The views prefixed with V$CELL_ contain internal statistical information, which is used by Oracle Support Services.

This includes the following views:

  • V$CELL_CONFIG
  • V$CELL_CONFIG_INFO
  • V$CELL_THREAD_HISTORY
  • V$CELL_DB
  • V$CELL_DISK
  • V$CELL_DISK_HISTORY
  • V$CELL_GLOBAL
  • V$CELL_GLOBAL_HISTORY
  • V$CELL_IOREASON
  • V$CELL_IOREASON_NAME
  • V$CELL_METRIC_DESC
  • V$CELL_REQUEST_TOTALS
  • V$CELL_STATE
  • V$CELL_THREAD_HISTORY
  • V$CELL_OFL_THREAD_HISTORY
  • V$CELL_OPEN_ALERTS

These views contain instantaneous statistical information that may be easily misinterpreted or incomplete when viewed in isolation. Instead, use the corresponding Automatic Workload Repository (AWR) views, which are prefixed with DBA_HIST_CELL_. Or, use the AWR report.

C.1.3 Using V$BACKUP_DATAFILE with Oracle Exadata Storage Server

The V$BACKUP_DATAFILE view contains columns relevant to Oracle Exadata Storage Server during Oracle Recovery Manager (RMAN) incremental backups.

Table C-2 V$BACKUP_DATAFILE Columns and Descriptions

Column Description

BLOCKS

Size of the backup data file in blocks.

BLOCKS_READ

The number of blocks that were scanned while taking this backup. If this is an incremental backup, and block change tracking was used to optimize the backup, then the value of this column is smaller than DATAFILE_BLOCKS. Otherwise, the value of this column is the same as DATAFILE_BLOCKS.

BLOCKS_SKIPPED_IN_CELL

The number of blocks that were read and filtered at the Oracle Exadata Storage Server to optimize the RMAN incremental backup.

DATAFILE_BLOCKS

Size of the data file in blocks at backup time. This value is also the number of blocks taken by the data file restarted from this backup.

The percentage of blocks skipped by Oracle Exadata System Software is calculated as follows:

(BLOCKS_SKIPPED_IN_CELL / BLOCKS_READ) * 100

This number changes significantly based on block change tracking.

If block change tracking for fast incremental backups is used, then most of the filtering is done at the database using the change tracking file, and the blocks are skipped before making an I/O request to the cell. If block change tracking is not used, then all of the blocks are filtered at the cell.

C.1.4 Using V$ASM_DISK_SPARSE and V$ASM_DISKGROUP_SPARSE to Monitor Sparse Disks

The V$ASM_DISK_SPARSE and V$ASM_DISKGROUP_SPARSE views contain information about sparse disks.

Table C-3 V$ASM_DISK_SPARSE Columns and Descriptions

Column Description

GROUP_NUMBER

The number of the disk group containing the disk.

DISK_NUMBER

The number assigned to the disk within this disk group.

INCARNATION

The incarnation number for the disk.

ALLOCATED_MAT_MB

The total used physical and materialized capacity on the disk.

TOTAL_MAT_MB

The total physical capacity on the disk.

SPARSE_READS

The total number of I/O read requests on non-materialized regions of the disk.

SPARSE_BYTES_READ

The total number of bytes read from non-materialized regions of the disk.

SPARSE_READ_TIME

The time taken by sparse read I/O operations.

Table C-4 V$ASM_DISKGROUP_SPARSE Columns and Descriptions

Column Description

GROUP_NUMBER

The cluster-wide number assigned to the disk group.

ALLOCATED_MAT_MB

The total used physical and materialized capacity of the disk group.

TOTAL_MAT_MB

The total physical capacity of the disk group.

C.2 Automatic Workload Repository Views

The Automatic Workload Repository (AWR) views contain information that is specific to Oracle Exadata Database Machine.

C.2.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.

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.

C.2.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

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CURRENT_SNAP_ID

NUMBER

NOT NULL

AWR snapshot identifier for when the disk group was captured.

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.

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.

C.2.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.

NUM_FAILGROUP

NUMBER

Number of failure groups in the disk group.

STATE

VARCHAR2(32)

State of the disk group.

See also V$ASM_DISKGROUP.

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.

C.2.4 DBA_HIST_ASM_DISK_STAT_SUMMARY

The DBA_HIST_ASM_DISK_STAT_SUMMARY view displays historic summary information about Oracle ASM disk groups. It aggregates information from V$ASM_DISK_STAT.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

INSTANCE_NUMBER

NUMBER

NOT NULL

Database instance number.

GROUP_NUMBER

NUMBER

NOT NULL

Cluster-wide number assigned to the disk group.

READS

NUMBER

Total number of I/O read requests for all disks in the disk group.

WRITES

NUMBER

Total number of I/O write requests for all disks in the disk group.

READ_ERRS

NUMBER

Total number of failed I/O read requests for all disks in the disk group.

WRITE_ERRS

NUMBER

Total number of failed I/O write requests for all disks in the disk group.

READ_TIMEOUT

NUMBER

Total number of failed I/O read requests that are timed out for all disks in the disk group.

WRITE_TIMEOUT

NUMBER

Total number of failed I/O write requests that are timed out for all disks in the disk group.

READ_TIME

NUMBER

Total I/O time (in seconds) for read requests for all disks in the disk group.

WRITE_TIME

NUMBER

Total I/O time (in seconds) for write requests for all disks in the disk group.

BYTES_READ

NUMBER

Total number of bytes read for all disks in the disk group.

BYTES_WRITTEN

NUMBER

Total number of bytes written for all disks in the disk group.

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.

C.2.5 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.

CURRENT_SNAP_ID

NUMBER

NOT NULL

AWR snapshot identifier for when the configuration was captured.

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.

  • IORM_OBJ: IORM objective.

  • OFFLOAD: configuration information for offload servers.

  • PHYSICALDISK: configuration information about physical disks.

CONFVAL

CLOB

XML data associated with CONFTYPE.

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.

C.2.6 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 about the cell.

  • CELLDISK: configuration information about cell disks.

  • GRIDDISK: configuration information about grid disks.

  • IORM_OBJ: IORM objective.

  • OFFLOAD: configuration information for offload servers.

  • PHYSICALDISK: configuration information about physical disks.

CONFVAL

CLOB

XML data associated with the CONFTYPE.

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.

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.

C.2.8 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.

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.

C.2.9 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.

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.

C.2.10 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.

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.

C.2.11 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.

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.

C.2.12 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.

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.

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

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.

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.

C.2.14 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.

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.

C.2.15 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.

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.

C.2.16 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.

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.

C.2.17 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.

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.