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.
- Using the V$CELL and GV$CELL Views to Display Oracle Exadata Storage Server Identification
TheV$CELL
view provides identifying information about cells. - About the V$CELL_ Views
The views prefixed withV$CELL_
contain internal statistical information, which is used by Oracle Support Services. - Using V$BACKUP_DATAFILE with Oracle Exadata Storage Server
TheV$BACKUP_DATAFILE
view contains columns relevant to Oracle Exadata Storage Server during Oracle Recovery Manager (RMAN) incremental backups. - Using V$ASM_DISK_SPARSE and V$ASM_DISKGROUP_SPARSE to Monitor Sparse Disks
TheV$ASM_DISK_SPARSE
andV$ASM_DISKGROUP_SPARSE
views contain information about sparse disks.
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 |
---|---|
|
A numeric hash value for the cell. For example: 138889696 Note: The cell hash value is often contained in the |
|
A character string (maximum 400) that specifies the IP addresses of the cell. These are the IP addresses specified in the |
|
The type of storage cell. Either |
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.
Parent topic: Oracle Database Dictionary Views
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.
Related Topics
Parent topic: Oracle Database Dictionary Views
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 |
---|---|
|
Size of the backup data file in blocks. |
|
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 |
|
The number of blocks that were read and filtered at the Oracle Exadata Storage Server to optimize the RMAN incremental backup. |
|
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.
Parent topic: Oracle Database Dictionary Views
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. |
|
The number assigned to the disk within this disk group. |
|
The incarnation number for the disk. |
|
The total used physical and materialized capacity on the disk. |
|
The total physical capacity on the disk. |
|
The total number of I/O read requests on non-materialized regions of the disk. |
|
The total number of bytes read from non-materialized regions of the disk. |
|
The time taken by sparse read I/O operations. |
Table C-4 V$ASM_DISKGROUP_SPARSE Columns and Descriptions
Column | Description |
---|---|
|
The cluster-wide number assigned to the disk group. |
|
The total used physical and materialized capacity of the disk group. |
|
The total physical capacity of the disk group. |
Parent topic: Oracle Database Dictionary Views
C.2 Automatic Workload Repository Views
The Automatic Workload Repository (AWR) views contain information that is specific to Oracle Exadata.
- DBA_HIST_ASM_BAD_DISK
- DBA_HIST_ASM_DISKGROUP
- DBA_HIST_ASM_DISKGROUP_STAT
- DBA_HIST_ASM_DISK_STAT_SUMMARY
- DBA_HIST_CELL_CONFIG
- DBA_HIST_CELL_CONFIG_DETAIL
- DBA_HIST_CELL_DB
- DBA_HIST_CELL_DISKTYPE
- DBA_HIST_CELL_DISK_NAME
- DBA_HIST_CELL_DISK_SUMMARY
- DBA_HIST_CELL_GLOBAL
- DBA_HIST_CELL_GLOBAL_SUMMARY
- DBA_HIST_CELL_IOREASON
- DBA_HIST_CELL_IOREASON_NAME
- DBA_HIST_CELL_METRIC_DESC
- DBA_HIST_CELL_NAME
- DBA_HIST_CELL_OPEN_ALERTS
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Number of the disk group containing the disk. |
|
VARCHAR2(128) |
NOT NULL |
Name of the disk. |
|
VARCHAR2(256) |
Operating system path name portion of the name returned by discovery. |
|
|
VARCHAR2(8) |
NOT NULL |
Global status for the disk. Only non-online disks are stored in this view. |
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
AWR snapshot identifier for when the disk group was captured. |
|
NUMBER |
NOT NULL |
Cluster-wide number assigned to the disk group. |
|
VARCHAR2(128) |
NOT NULL |
Name of the disk group. |
|
VARCHAR2(6) |
Redundancy type for the disk group. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Cluster-wide number assigned to the disk group. |
|
NUMBER |
Total capacity of the disk group in MB. |
|
|
NUMBER |
Unused capacity in MB of the disk group. |
|
|
NUMBER |
Number of disks in the disk group. |
|
|
NUMBER |
Number of failure groups in the disk group. |
|
|
VARCHAR2(32) |
State of the disk group. See also V$ASM_DISKGROUP. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Database instance number. |
|
NUMBER |
NOT NULL |
Cluster-wide number assigned to the disk group. |
|
NUMBER |
Total number of I/O read requests for all disks in the disk group. |
|
|
NUMBER |
Total number of I/O write requests for all disks in the disk group. |
|
|
NUMBER |
Total number of failed I/O read requests for all disks in the disk group. |
|
|
NUMBER |
Total number of failed I/O write requests for all disks in the disk group. |
|
|
NUMBER |
Total number of failed I/O read requests that are timed out for all disks in the disk group. |
|
|
NUMBER |
Total number of failed I/O write requests that are timed out for all disks in the disk group. |
|
|
NUMBER |
Total I/O time (in seconds) for read requests for all disks in the disk group. |
|
|
NUMBER |
Total I/O time (in seconds) for write requests for all disks in the disk group. |
|
|
NUMBER |
Total number of bytes read for all disks in the disk group. |
|
|
NUMBER |
Total number of bytes written for all disks in the disk group. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
AWR snapshot identifier for when the configuration was captured. |
|
VARCHAR2(256) |
NOT NULL |
Unique identifier for the cell. |
|
NUMBER |
NOT NULL |
Hash number to uniquely identify the cell. |
|
VARCHAR2(15) |
NOT NULL |
Configuration type. The configuration type determines the type of information stored in the CONFVAL column.
|
|
CLOB |
XML data associated with CONFTYPE. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
VARCHAR2(256) |
NOT NULL |
Unique identifier for the cell. |
|
NUMBER |
NOT NULL |
Hash number to uniquely identify the cell. |
|
VARCHAR2(15) |
NOT NULL |
Configuration type. The configuration type determines the type of information stored in the CONFVAL column.
|
|
CLOB |
XML data associated with the CONFTYPE. |
|
|
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
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number to uniquely identify the cell. |
|
VARCHAR2(4000) |
User-readable cell name. |
|
|
VARCHAR2(4000) |
The type of hard disk. The format of which is H/size, where size is suffixed by G, or T. |
|
|
VARCHAR2(4000) |
The type of flash, the format of which is F/size, where size is suffixed by G, or T. |
|
|
NUMBER |
Number of cell disks. |
|
|
NUMBER |
Number of grid disks. |
|
|
NUMBER |
Number of hard disks. |
|
|
NUMBER |
Number of flash disks. |
|
|
NUMBER |
The maximum number of IOPs for the hard disk type. |
|
|
NUMBER |
The maximum number of IOPs for the flash disk type. |
|
|
NUMBER |
The maximum I/O throughput for the hard disk type, in megabytes per second. |
|
|
NUMBER |
The maximum I/O throughput for the flash disk type, in megabytes per second. |
|
|
NUMBER |
The maximum number of hard disk IOPs for the cell. This is calculated using MAX_DISK_IOPS*NUM_HARD_DISKS. |
|
|
NUMBER |
The maximum number of flash IOPs for the cell. This is calculated using MAX_FLASH_IOPS*NUM_FLASH_DISKS. |
|
|
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. |
|
|
NUMBER |
The maximum I/O throughput flash for the cell, in megabytes per second. This is calculated using MAX_FLASH_MBPS*NUM_FLASH_DISKS. |
|
|
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
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 |
---|---|---|---|
|
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 |
Unique identifier of the disk. |
|
VARCHAR2(4000) |
User-readable cell name. |
|
|
VARCHAR2(4000) |
Disk type, either FlashDisk or HardDisk. |
|
|
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
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 |
---|---|---|---|
|
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 |
Unique identifier of the disk. |
|
NUMBER |
Number of one-minute samples the summary is based on. |
|
|
NUMBER |
Sum of the per-minute disk utilization metrics. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute read requests metrics per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute read metrics, in megabytes per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute write requests metrics, per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute write metrics, in megabytes per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute IOPs. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute I/O metrics, in megabytes per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute service time metrics. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute wait time metrics. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute small read requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small write requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large read requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large write requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small read bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small write bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large read bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large write bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small read latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small write latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large read latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large write latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute IOPs metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute I/O metrics, in megabytes per second. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute I/O latency metrics. This data is from cell server statistics. |
|
|
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. |
|
|
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. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number that uniquely identifies the cell. |
|
NUMBER |
NOT NULL |
Incarnation number of the cell. |
|
NUMBER |
NOT NULL |
Metric_id that identifies the metric. |
|
VARCHAR2(257) |
Name of the metric. |
|
|
NUMBER |
The value of the metric. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot ID |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number that uniquely identifies the cell. |
|
NUMBER |
NOT NULL |
Incarnation number of the cell. |
|
NUMBER |
Number of 1 minute samples the summary is based on. |
|
|
NUMBER |
Sum of the per-minute CPU usage percentage metrics. |
|
|
NUMBER |
Sum of the per-minute system CPU usage percentage metrics. |
|
|
NUMBER |
Sum of the per-minute user CPU usage percentage metrics. |
|
|
NUMBER |
Sum of the per-minute network received metrics, in bytes per second. |
|
|
NUMBER |
Sum of the per-minute network sent metrics, in bytes per second. |
|
|
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. |
|
|
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. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number that uniquely identifies the cell. |
|
NUMBER |
NOT NULL |
Incarnation number of the cell. |
|
NUMBER |
NOT NULL |
Unique identifier for the I/O reason. |
|
VARCHAR2(257) |
User readable I/O reason. |
|
|
NUMBER |
Number of I/O requests performed for the reason. |
|
|
NUMBER |
Number of IO Bytes performed for the reason. |
|
|
NUMBER |
The database identifier. |
|
|
NUMBER |
The identifier of the container identified by CON_DBID. Possible values are as follows:
|
|
|
NUMBER |
Number of read requests for the reason. This value includes the flash reads counted in the
|
|
|
NUMBER |
Number of write requests for the reason. This value includes the flash writes counted in the
|
|
|
NUMBER |
Number of flash read requests for the reason. This value is a subset of the value in the
|
|
|
NUMBER |
Number of flash write requests for the reason. This value is a subset of the value in the
|
Parent topic: Automatic Workload Repository Views
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Unique identifier for an I/O reason. |
|
VARCHAR2(257) |
User-readable description of the I/O reason. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Unique identifier for the metric |
|
VARCHAR2(257) |
User-readable metric name |
|
|
VARCHAR2(17) |
NOT NULL |
Unit for the metrics, if NULL this is a count. |
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number that uniquely identifies the cell. |
|
VARCHAR2(4000) |
User-readable cell name. |
|
|
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
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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number that uniquely identifies the cell. |
|
DATE |
NOT NULL |
Time that the alert was opened. |
|
NUMBER |
NOT NULL |
Sequence number of the alert. |
|
VARCHAR2(1024) |
Message describing the alert. |
|
|
VARCHAR2(1) |
Whether or not the alert has state. |
|
|
VARCHAR2(64) |
The severity of the alert. Possible values are as follows:
|
|
|
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