Oracle Exadata extension

  • Latest Dynatrace
  • Extension
  • Published Oct 27, 2025

Monitor Oracle Exadata systems for performance, usage and availability

An example Exadata performance dashboard.Exadata servers, with base characteristics.Server characteristics on the infrastructure levelExadata Flash performance - cache and disksExadata database server machine analysisExadata cell analysis screen
1 of 6An example Exadata performance dashboard.

Get started

Overview

Oracle Exadata extension connects to your Exadata devices and collects Exadata characteristics published by the Oracle Prometheus exporter. Metrics collected are continuously analyzed on Dynatrace platform, leveraging topological Exadata model that the extension maintains. Unified analysis screens offer insight into health and performance of the Exadata platform, including storage server and its components, such as flash cache, cell disks, and grid disks. Out of the box alerts notify on critical issues with the Exadata resources, including memory, CPU and I/O latency.

This extension is intended for users, who

  • Look to reliably monitor Exadata components and resource utilization with comprehensive dashboards and screens
  • Want to take pre-emptive measures to avoid service degradations rooting down to the Exadata resources oversubscription
  • Want to leverage rich observability signals provided out-of-the-box by the Exadata Prometheus exporters
  • Use Dynatrace for infrastructure monitoring and look to extend Dynatrace insights into the Exadata tier of their end-to-end infrastructure

Use cases

  • Integrated operational monitoring of the infrastructure, including Exadata
  • Early alerting on anomalies mounting in Exadata resource usage patterns
  • Root cause analysis of the Exadata bottlenecks, in the light of the entire application and infrastructure landscape observed by Dynatrace

Requirements

Follow the instructions for Using Real-Time Insight in the Oracle Exadata System Software User's Guide to configure metric stream for each type of server you want to monitor. Use the following script in DBMCLI on Database Servers (including VMs) and CELLCLI on Storage Servers to create a user with the appropriate privileges to consume the metrics. You need to perform this operation on every server you want to monitor.

CREATE ROLE realtime_collector
GRANT PRIVILEGE LIST ON METRICSTREAM ALL ATTRIBUTES WITH ALL OPTIONS TO ROLE realtime_collector
CREATE USER realtime_collector PASSWORD="password" ### Don't forget to change this password
GRANT ROLE realtime_collector to user realtime_collector

Compatibility information

  • Network access from a Dynatrace ActiveGate to the Exadata endpoints specified in the Get started section
  • Oracle Exadata System Software 22.1.0+
    • This Extension uses API introduced in Exadata System Software 22.1.0
    • Your Exadata Database Machine and Exadata Storage Server would carry the same version number as the Exadata System Software indicates
  • Note that this extension does not support ExaCC

Activation and setup

  1. Activate the extension in your Dynatrace environment web UI using the in-product Hub and choose Monitor remotely.
  2. Provide the required Prometheus exporter endpoint configuration:
  3. Endpoint for storage servers: https://server-name/metricstream/list?stream=true
  4. Endpoint for database servers using port 7879: https://server-name:7879/metricstream/list?stream=true
  5. Use Basic authentication with the user realtime_collector and the password set in DBMCLI and CELLCLI.
  6. For one Exadata system, create one extension configuration and configure Exadata endpoints for individual servers and cells within it. If you have multiple Exadata systems, create a configuration for each Exadata system and differentiate the Exadata system via the "Fleet" field.

Details

The extension package contains

  • Python scripts that connect to the Exadata endpoints and scrape the metrics
  • Topology and relationship definitions for Exadata entities
  • A dashboard offering high-level Exadata platform overview
  • Unified Analysis pages for each Exadata entity

Summary of the entities monitored

The Oracle Exadata extension collects metrics for:

  • Exadata Server
  • Exadata DB Server Filesystem
  • Exadata Cell Filesystem
  • Exadata Net Interface
  • Exadata PMEM Cache
  • Exadata Disk
  • Exadata Grid Disk
  • Exadata Cell Disk
  • Exadata Cell
  • Exadata DB Server
  • Exadata IORM Database
  • Exadata IORM Pluggable Database
  • Exadata IORM pluggable database on cell
  • Exadata IORM Consumer Group
  • Exadata IORM Cluster
  • Exadata Flash Cache
  • Exadata Flash Cache on cell
  • Exadata Flash Cache on DB
  • Exadata Flash Cache on PDB

Licensing and cost

There is no charge for obtaining the extension, only for the data that the extension ingests. The details of license consumption will depend on which licensing model you are using. This will either be Dynatrace classic licensing or the Dynatrace Platform Subscription (DPS) model.

Metrics

License consumption is based on the number of metric data points ingested. The following formula will provide approximate annual data points ingested assuming all feature sets are enabled.

(
( 19 * the number of servers )
+ ( 10 * the number of servers * the number of disks on the server )
+ ( 6 * the number of servers * the number of network interfaces on the server )
+ ( 12 * the number of database servers )
+ ( 1 * the number of database servers * the number of file systems on the DB server )
+ ( 1 * the number of cell servers * the number of file systems on the cell server )
+ ( 25 * the number of cell servers * the number of disks on the cell server )
+ ( 99 * the number of cell servers )
+ ( 16 * the number of cell servers * the number of databases on the cell server )
+ ( 16 * the number of cell servers * the number of pluggable databases on the cell server )
+ ( 5 * the number of cell servers * the number of DB/PDB * the number of consumer groups on the DB/PDB )
+ ( 2 * the number of category plans * the number of cell servers )
+ ( 2 * the number of IP addresses in queue )
+ ( 7 * the number of servers * (4 * the number of ROCE interfaces on the server) )
+ ( 6 * the number of cell servers * (2 * the number of cell disks on the cell server) )
) * 60 minutes * 24 hours * 365 days data points per year

Classic licensing

In the classic licensing model, metric ingestion will consume Davis Data Units (DDUs) at the rate of .001 DDUs per metric data point. Multiply the above formula for annual data points by .001 to estimate annual DDU usage.

Feature sets

When activating your extension using monitoring configuration, you can limit monitoring to one of the feature sets. To work properly the extension has to collect at least one metric after the activation.

In highly segmented networks, feature sets can reflect the segments of your environment. Then, when you create a monitoring configuration, you can select a feature set and a corresponding ActiveGate group that can connect to this particular segment.

All metrics that aren't categorized into any feature set are considered to be the default and are always reported.

A metric inherits the feature set of a subgroup, which in turn inherits the feature set of a group. Also, the feature set defined on the metric level overrides the feature set defined on the subgroup level, which in turn overrides the feature set defined on the group level.

Metric nameMetric keyDescription
PMEM DB cache MB allocatedoracle.exadata.DB_PC_BY_ALLOCATEDNumber of megabytes allocated in PMEM cache for this database
PMEM cache MB allocated totaloracle.exadata.PC_BY_ALLOCATEDNumber of megabytes allocated in PMEM cache
PMEM PDB cache MB allocatedoracle.exadata.PDB_PC_BY_ALLOCATEDNumber of megabytes allocated in PMEM cache for this pluggable database
Metric nameMetric keyDescription
FlashCache IO MBpsoracle.exadata.CG_FC_IO_BY_SECNumber of megabytes of I/O per second for this consumer group to flash cache
FC large request IOPSoracle.exadata.CG_FC_IO_RQ_LG_SECNumber of large IO requests issued by a consumer group to flash cache per second
FlashCache IOPSoracle.exadata.CG_FC_IO_RQ_SECNumber of IO requests issued by a consumer group to flash cache per second
FC small request IOPSoracle.exadata.CG_FC_IO_RQ_SM_SECNumber of small IO requests issued by a consumer group to flash cache per second
FlashDisks IO Mbpsoracle.exadata.CG_FD_IO_BY_SECNumber of megabytes of I/O per second for this consumer group to flash disks
FlashDisks IO load (avg)oracle.exadata.CG_FD_IO_LOADAverage I/O load from this consumer group for flash disks
FD large request IOPSoracle.exadata.CG_FD_IO_RQ_LG_SECNumber of large IO requests issued by a consumer group to flash disks per second
FD small request IOPSoracle.exadata.CG_FD_IO_RQ_SM_SECNumber of small IO requests issued by a consumer group to flash disks per second
FD RW latency (cumulative)oracle.exadata.CG_FD_IO_TMThe cumulative latency of reading or writing blocks by a consumer group from flash disks
FD large RW latency (cumulative)oracle.exadata.CG_FD_IO_TM_LGThe cumulative latency of reading or writing large blocks by a consumer group from flash disks
FD large RW latency rate (us/req)oracle.exadata.CG_FD_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request by a consumer group from flash disks
FD RW latency rate (us/req)oracle.exadata.CG_FD_IO_TM_RQThe rate which is the average latency of reading or writing blocks per request by a consumer group from flash disks
FD small RW latency (cumulative)oracle.exadata.CG_FD_IO_TM_SMThe cumulative latency of reading or writing small blocks by a consumer group from flash disks
FD small RW latency rate (us/req)oracle.exadata.CG_FD_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request by a consumer group from flash disks
IORM wait for large requestsoracle.exadata.CG_FD_IO_WT_LGIORM wait time for large IO requests issued to flashdisks by a consumer group
IORM wait /req for large requests (avg)oracle.exadata.CG_FD_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to flash disks by a consumer group
IORM wait for small requestsoracle.exadata.CG_FD_IO_WT_SMIORM wait time for small IO requests issued to flashdisks by a consumer group
IORM wait /req for small requests (avg)oracle.exadata.CG_FD_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to flash disks by a consumer group
Hard disks IO MBpsoracle.exadata.CG_IO_BY_SECNumber of megabytes of I/O per second for this consumer group to hard disks
Hard disks IO load (avg)oracle.exadata.CG_IO_LOADAverage I/O load from this consumer group for hard disks
HDD large request IOPSoracle.exadata.CG_IO_RQ_LG_SECNumber of large IO requests issued by a consumer group to hard disks per second
HDD small request IOPSoracle.exadata.CG_IO_RQ_SM_SECNumber of small IO requests issued by a consumer group to hard disks per second
HDD large RW latency (cumulative)oracle.exadata.CG_IO_TM_LGThe cumulative latency of reading or writing large blocks by a consumer group from hard disks
HDD large RW latency rate (us/req)oracle.exadata.CG_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request by a consumer group from hard disks
HDD small RW latency (cumulative)oracle.exadata.CG_IO_TM_SMThe cumulative latency of reading or writing small blocks by a consumer group from hard disks
HDD small RW latency rate (us/req)oracle.exadata.CG_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request by a consumer group from hard disks
IORM wait for large requestsoracle.exadata.CG_IO_WT_LGIORM wait time for large IO requests issued to hard disks by a consumer group
IORM wait /req for large requests (avg)oracle.exadata.CG_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to hard disks by a consumer group
IORM wait for small requestsoracle.exadata.CG_IO_WT_SMIORM wait time for small IO requests issued to hard disks by a consumer group
IORM wait /req for small requests (avg)oracle.exadata.CG_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to hard disks by a consumer group
Metric nameMetric keyDescription
FlashCache MB allocatedoracle.exadata.DB_FC_BY_ALLOCATEDNumber of megabytes allocated in flash cache for this database
FlashCache IO MBpsoracle.exadata.DB_FC_IO_BY_SECNumber of megabytes of I/O per second for this database to flash cache
FC large request IOPSoracle.exadata.DB_FC_IO_RQ_LG_SECNumber of large IO requests issued by a database to flash cache per second
FC small request IOPSoracle.exadata.DB_FC_IO_RQ_SM_SECNumber of small IO requests issued by a database to flash cache per second
FD large request IOPSoracle.exadata.DB_FD_IO_RQ_LG_SECNumber of large IO requests issued by a database to flash disks per second
FD small request IOPSoracle.exadata.DB_FD_IO_RQ_SM_SECNumber of small IO requests issued by a database to flash disks per second
FD large RW latency rate (us/req)oracle.exadata.DB_FD_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request by a database from flash disks
FD small RW latency rate (us/req)oracle.exadata.DB_FD_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request by a database from flash disks
IORM wait /req for large requests (avg)oracle.exadata.DB_FD_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to flash disks by a database
IORM wait /req for small requests (avg)oracle.exadata.DB_FD_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to flash disks by a database
HDD large request IOPSoracle.exadata.DB_IO_RQ_LG_SECNumber of large IO requests issued by a database to hard disks per second
HDD small request IOPSoracle.exadata.DB_IO_RQ_SM_SECNumber of small IO requests issued by a database to hard disks per second
HDD large RW latency rate (us/req)oracle.exadata.DB_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request by a database from hard disks
HDD small RW latency rate (us/req)oracle.exadata.DB_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request by a database from hard disks
IORM wait /req for large requests (avg)oracle.exadata.DB_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to hard disks by a database
IORM wait /req for small requests (avg)oracle.exadata.DB_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to hard disks by a database
Metric nameMetric keyDescription
FC large request IOPSoracle.exadata.CT_FC_IO_RQ_LG_SECNumber of large IO requests issued by an IORM category to flash cache per second
FlashCache IOPSoracle.exadata.CT_FC_IO_RQ_SECNumber of IO requests issued by an IORM category to flash cache per second
FC small request IOPSoracle.exadata.CT_FC_IO_RQ_SM_SECNumber of small IO requests issued by an IORM category to flash cache per second
FlashDisks IO load (avg)oracle.exadata.CT_FD_IO_LOADAverage I/O load from this category for flash disks
FD large request IOPSoracle.exadata.CT_FD_IO_RQ_LG_SECNumber of large IO requests issued by an IORM category to flash disks per second
FD small request IOPSoracle.exadata.CT_FD_IO_RQ_SM_SECNumber of small IO requests issued by an IORM category to flash disks per second
FD RW latency (cumulative)oracle.exadata.CT_FD_IO_TMThe cumulative latency of reading or writing blocks for this category from flash disks
FD large RW latency (cumulative)oracle.exadata.CT_FD_IO_TM_LGThe cumulative latency of reading or writing large blocks for this category from flash disks
FD large RW latency rate (us/req)oracle.exadata.CT_FD_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request for this category from flash disks
FD RW latency rate (us/req)oracle.exadata.CT_FD_IO_TM_RQThe rate which is the average latency of reading or writing blocks per request for this category from flash disks
FD small RW latency (cumulative)oracle.exadata.CT_FD_IO_TM_SMThe cumulative latency of reading or writing small blocks for this category from flash disks
FD small RW latency rate (us/req)oracle.exadata.CT_FD_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request for this category from flash disks
Flash utilizationoracle.exadata.CT_FD_IO_UTILPercentage of flash resources utilized by this category
Flash utilization by large requestsoracle.exadata.CT_FD_IO_UTIL_LGPercentage of flash resources utilized by large requests from this category
Flash utilization by small requestsoracle.exadata.CT_FD_IO_UTIL_SMPercentage of flash resources utilized by small requests from this category
IORM wait for large requestsoracle.exadata.CT_FD_IO_WT_LGIORM wait time for large IO requests issued to flash disks by an IORM category
IORM wait /req for large requests (avg)oracle.exadata.CT_FD_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to flash disks by an IORM category
IORM wait for small requestsoracle.exadata.CT_FD_IO_WT_SMIORM wait time for small IO requests issued to flash disks by an IORM category
IORM wait /req for small requests (avg)oracle.exadata.CT_FD_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to flash disks by an IORM category
Hard disks IO MBpsoracle.exadata.CT_IO_BY_SECNumber of megabytes of I/O per second for this category to hard disks
Hard disks IO load (avg)oracle.exadata.CT_IO_LOADAverage I/O load from this category for hard disks
HDD large request IOPSoracle.exadata.CT_IO_RQ_LG_SECNumber of large IO requests issued by an IORM category to hard disks per second
HDD small request IOPSoracle.exadata.CT_IO_RQ_SM_SECNumber of small IO requests issued by an IORM category to hard disks per second
HDD large RW latency (cumulative)oracle.exadata.CT_IO_TM_LGThe cumulative latency of reading or writing large blocks for this category from hard disks
HDD large RW latency rate (us/req)oracle.exadata.CT_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request for this category from hard disks
HDD small RW latency (cumulative)oracle.exadata.CT_IO_TM_SMThe cumulative latency of reading or writing small blocks for this category from hard disks
HDD small RW latency rate (us/req)oracle.exadata.CT_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request for this category from hard disks
Disk utilization by large requestsoracle.exadata.CT_IO_UTIL_LGPercentage of disk resources utilized by large requests from this category
Disk utilization by small requestsoracle.exadata.CT_IO_UTIL_SMPercentage of disk resources utilized by small requests from this category
IORM wait for large requestsoracle.exadata.CT_IO_WT_LGIORM wait time for large IO requests issued to hard disks by an IORM category
IORM wait /req for large requests (avg)oracle.exadata.CT_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to hard disks by an IORM category
IORM wait for small requestsoracle.exadata.CT_IO_WT_SMIORM wait time for small IO requests issued to hard disks by an IORM category
IORM wait /req for small requests (avg)oracle.exadata.CT_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to hard disks by an IORM category
Metric nameMetric keyDescription
Redo data saved on flash due to disk I/O errorsoracle.exadata.FL_BY_KEEPThe amount of redo data saved on flash due to disk I/O errors
Flash Logging efficiencyoracle.exadata.FL_EFFICIENCY_PERCENTAGEThe efficiency of Smart Flash Logging expressed as a percentage
Flash Logging efficiency past houroracle.exadata.FL_EFFICIENCY_PERCENTAGE_HOURThe efficiency of Smart Flash Logging over the last hour expressed as a percentage
Metric nameMetric keyDescription
FlashCache IOPSoracle.exadata.DB_FC_IO_RQ_SECNumber of IO requests issued by a database to flash cache per second
FlashDisks IO Mbpsoracle.exadata.DB_FD_IO_BY_SECNumber of megabytes of I/O per second for this database to flash disks
FlashDisks IO load (avg)oracle.exadata.DB_FD_IO_LOADAverage I/O load from this database for flash disks
FD RW latency (cumulative)oracle.exadata.DB_FD_IO_TMThe cumulative latency of reading or writing blocks by a database from flash disks
FD large RW latency (cumulative)oracle.exadata.DB_FD_IO_TM_LGThe cumulative latency of reading or writing large blocks by a database from flash disks
FD RW latency rate (us/req)oracle.exadata.DB_FD_IO_TM_RQThe rate which is the average latency of reading or writing blocks per request by a database from flash disks
FD small RW latency (cumulative)oracle.exadata.DB_FD_IO_TM_SMThe cumulative latency of reading or writing small blocks by a database from flash disks
Flash utilizationoracle.exadata.DB_FD_IO_UTILPercentage of flash resources utilized by this database
Flash utilization by large requestsoracle.exadata.DB_FD_IO_UTIL_LGPercentage of flash resources utilized by large requests from this database
Flash utilization by small requestsoracle.exadata.DB_FD_IO_UTIL_SMPercentage of flash resources utilized by small requests from this database
IORM wait for large requestsoracle.exadata.DB_FD_IO_WT_LGIORM wait time for large IO requests issued to flash disks by a database
IORM wait for small requestsoracle.exadata.DB_FD_IO_WT_SMIORM wait time for small IO requests issued to flash disks by a database
Flash Log MB writtenoracle.exadata.DB_FL_IO_BYThe number of MB written to the Flash Log
Flash Log write rate MBpsoracle.exadata.DB_FL_IO_BY_SECThe number of MB written per second to the Flash Log
Flash Log request IOPSoracle.exadata.DB_FL_IO_RQ_SECThe number of I/O requests per second issued to the Flash Log
Hard disks IO MBpsoracle.exadata.DB_IO_BY_SECNumber of megabytes of I/O per second for this database to hard disks
Hard disks IO load (avg)oracle.exadata.DB_IO_LOADAverage I/O load from this database for hard disks
HDD large RW latency (cumulative)oracle.exadata.DB_IO_TM_LGThe cumulative latency of reading or writing large blocks by a database from hard disks
HDD small RW latency (cumulative)oracle.exadata.DB_IO_TM_SMThe cumulative latency of reading or writing small blocks by a database from hard disks
Disk utilization by large requestsoracle.exadata.DB_IO_UTIL_LGPercentage of disk resources utilized by large requests from this database
Disk utilization by small requestsoracle.exadata.DB_IO_UTIL_SMPercentage of disk resources utilized by small requests from this database
IORM wait for large requestsoracle.exadata.DB_IO_WT_LGIORM wait time for large IO requests issued to hard disks by a database
IORM wait for small requestsoracle.exadata.DB_IO_WT_SMIORM wait time for small IO requests issued to hard disks by a database
XRMEM DB cache MB allocatedoracle.exadata.DB_XRM_BY_ALLOCATEDNumber of megabytes allocated in XRMEM cache for this database
Metric nameMetric keyDescription
Eligible MB for smart IO offloadoracle.exadata.SIO_IO_EL_OFCumulative number of megabytes eligible for smart IO offload
Eligible MBps for smart IO offloadoracle.exadata.SIO_IO_EL_OF_SECNumber of megabytes per second eligible for smart IO offload
Interconnect returned MBoracle.exadata.SIO_IO_OF_RECumulative number of interconnect megabytes returned by smart IO
Interconnect returned MBpsoracle.exadata.SIO_IO_OF_RE_SECNumber of interconnect megabytes per second returned by smart IO
Passthru IO MBoracle.exadata.SIO_IO_PA_THCumulative number of megabytes of passthru IOs by smart IO
Passthru IO MBpsoracle.exadata.SIO_IO_PA_TH_SECNumber of megabytes per second of passthru IOs by smart IO
SIO reads MB from FlashCacheoracle.exadata.SIO_IO_RD_FCCumulative number of megabytes read from flash cache by smart IO
SIO reads MB totaloracle.exadata.SIO_IO_RD_FC_HDCumulative number of megabytes read from both flash cache and hard disk by smart IO
SIO reads MBps totaloracle.exadata.SIO_IO_RD_FC_HD_SECNumber of megabytes per second read from both flash cache and hard disk by smart IO
SIO reads MBps from FlashCacheoracle.exadata.SIO_IO_RD_FC_SECNumber of megabytes per second read from flash cache by smart IO
SIO reads MB from HDDoracle.exadata.SIO_IO_RD_HDCumulative number of megabytes read from hard disk by smart IO
SIO reads MBps from HDDoracle.exadata.SIO_IO_RD_HD_SECNumber of megabytes per second read from hard disk by smart IO
SIO read IOPS totaloracle.exadata.SIO_IO_RD_RQ_FC_HD_SECNumber of read IO requests per second from both flash cache and hard disk by smart IO
SIO FC read IOPSoracle.exadata.SIO_IO_RD_RQ_FC_SECNumber of read IO requests per second from flash cache by smart IO
SIO HDD read IOPSoracle.exadata.SIO_IO_RD_RQ_HD_SECNumber of read IO requests per second from hard disk by smart IO
DB node MB sent to balance CPUoracle.exadata.SIO_IO_RV_OFCumulative number of megabytes sent to DB node to balance CPU by smart IO
DB node MBps sent to balance CPUoracle.exadata.SIO_IO_RV_OF_SECNumber of megabytes per second sent to DB node to balance CPU by smart IO
Storage index save MBoracle.exadata.SIO_IO_SI_SVCumulative number of megabytes saved by storage index
Storage index save MBpsoracle.exadata.SIO_IO_SI_SV_SECNumber of megabytes per second saved by storage index
SIO FC population writes MBoracle.exadata.SIO_IO_WR_FCCumulative number of megabytes of flash cache population writes by smart IO
SIO FC population writes MBpsoracle.exadata.SIO_IO_WR_FC_SECNumber of megabytes per second of flash cache population writes by smart IO
SIO to HDD written MBoracle.exadata.SIO_IO_WR_HDCumulative number of megabytes written to hard disk by smart IO
SIO to HDD write MBpsoracle.exadata.SIO_IO_WR_HD_SECNumber of megabytes per second written to hard disk by smart IO
SIO FC population write IOPSoracle.exadata.SIO_IO_WR_RQ_FC_SECNumber of IO requests per second for flash cache population writes by smart IO
SIO to HDD write IOPSoracle.exadata.SIO_IO_WR_RQ_HD_SECNumber of write IO requests per second to hard disk by smart IO
Background SIO CPU time used (cumulative)oracle.exadata.SIO_BG_CPUCumulative CPU time used by background smart IO
Foreground SIO CPU time used (cumulative)oracle.exadata.SIO_FG_CPUCumulative CPU time used by foreground smart IO
BG PDB SIO CPU time used (cumulative)oracle.exadata.SIO_PDB_BG_CPUCumulative CPU time used by background smart IO for this pluggable database
BG PDB SIO CPU time used (us/sec)oracle.exadata.SIO_PDB_BG_CPU_SECCPU time used by background smart IO per second for this pluggable database
FG PDB SIO CPU time used (cumulstive)oracle.exadata.SIO_PDB_FG_CPUCumulative CPU time used by foreground smart IO for this pluggable database
FG PDB SIO CPU time used (us/sec)oracle.exadata.SIO_PDB_FG_CPU_SECCPU time used by foreground smart IO per second for this pluggable database
Metric nameMetric keyDescription
File system space utilizationoracle.exadata.CL_FSUTPercentage of total space on this file system that is currently used
Metric nameMetric keyDescription
Disk Controller Battery Temperatureoracle.exadata.DS_BBU_TEMPDisk Controller Battery Temperature
Disk Controller Battery Chargeoracle.exadata.DS_BBU_CHARGEDisk Controller Battery Charge
CPU not idle %oracle.exadata.DS_CPUTPercentage of time over the previous minute that the system CPUs were not idle.
CPU usage by MS %oracle.exadata.DS_CPUT_MSPercentage of CPU time used by MS
Fans working on the serveroracle.exadata.DS_FANSNumber of working fans on the server
Physical memory utilizationoracle.exadata.DS_MEMUTPercentage of total physical memory on this server that is currently used
Physical memory utilization by MSoracle.exadata.DS_MEMUT_MSPercentage of physical memory used by MS
Swap read speed kBpsoracle.exadata.DS_SWAP_IN_BY_SECAmount of swap pages read in KB per second
Swap write speed kBpsoracle.exadata.DS_SWAP_OUT_BY_SECAmount of swap pages written in KB per second
Swap used %oracle.exadata.DS_SWAP_USAGEPercentage of swap used
Temperature (Celsius) of the serveroracle.exadata.DS_TEMPTemperature (Celsius) of the server, provided by the BMC
Virtual memory used by MSoracle.exadata.DS_VIRTMEM_MSAmount of virtual memory used by MS in MB
Metric nameMetric keyDescription
Flash Logging MB written to hard diskoracle.exadata.FL_IO_DB_BY_WThe number of MB written to hard disk by Smart Flash Logging
Flash Logging write to hard disk MBpsoracle.exadata.FL_IO_DB_BY_W_SECThe rate which is the number of MB per second written to hard disk by Smart Flash Logging
Flash Logging MB written to flashoracle.exadata.FL_IO_FL_BY_WThe number of MB written to flash by Smart Flash Logging
Flash Logging write to flash MBpsoracle.exadata.FL_IO_FL_BY_W_SECThe rate which is the number of MB per second written to flash by Smart Flash Logging
Redo log writes cumulative latencyoracle.exadata.FL_IO_TM_WCumulative latency of all redo log writes
Redo log writes average latencyoracle.exadata.FL_IO_TM_W_RQAverage latency of all redo log writes
Redo writes skipped per minute due to not enough data on diskoracle.exadata.FL_IO_W_SKIP_BUSY_MINThe number of redo writes during the last minute that could not be serviced by Smart Flash Logging because too much data had not yet been written to disk
Redo log writes e2e cumulative latencyoracle.exadata.FL_RQ_TM_WCumulative latency of all redo log write requests (includes network and other processing overhead)
Redo log writes e2e average latencyoracle.exadata.FL_RQ_TM_W_RQAverage latency of all redo log write requests
Metric nameMetric keyDescription
Interface RX MBpsoracle.exadata.OS_NET_RX_BY_SECNumber of bytes received by the network interface
Interface CRC error rate (pps)oracle.exadata.OS_NET_RX_CRC_ERROR_SECNumber of packets with a CRC error received on the network interface
Interface RX drop rate (pps)oracle.exadata.OS_NET_RX_DRP_SECNumber of packets dropped by the network interface
Interface framing error rate (pps)oracle.exadata.OS_NET_RX_FRAME_ERROR_SECNumber of receiver-side frame alignment errors on the network interface
Interface TX MBpsoracle.exadata.OS_NET_TX_BY_SECNumber of bytes transmitted by the network interface
Interface TX drop rate (pps)oracle.exadata.OS_NET_TX_DRP_SECNumber of packets dropped by the network interface
Metric nameMetric keyDescription
Columnar FlashCache usedoracle.exadata.FC_COL_BY_USEDNumber of megabytes used in Columnar FlashCache
Eligible MBps to read from Columnar FCoracle.exadata.FC_COL_IO_BY_R_ELIGIBLE_SECNumber of megabytes per second eligible to read from Columnar FlashCache
Read IOPS from Columnar FCoracle.exadata.FC_COL_IO_RQ_R_SECNumber of requests per second that were read from Columnar FlashCache
Metric nameMetric keyDescription
FC keep pool read MBoracle.exadata.FC_IO_BYKEEP_RNumber of megabytes read from FlashCache for keep objects
FC keep pool read MBpsoracle.exadata.FC_IO_BYKEEP_R_SECNumber of megabytes read per second from FlashCache for keep objects
FC keep pool write MBoracle.exadata.FC_IO_BYKEEP_WNumber of megabytes written to FlashCache for keep objects
FC keep pool write MBpsoracle.exadata.FC_IO_BYKEEP_W_SECNumber of megabytes per second written to FlashCache for keep objects
MB written from FC to hard disksoracle.exadata.FC_IO_BY_DISK_WRITENumber of megabytes written from flash cache to hard disks
MBps written from FC to hard disksoracle.exadata.FC_IO_BY_DISK_WRITE_SECNumber of megabytes per second written from flash cache to hard disks
Bypass reads MB due to not mirrored IOoracle.exadata.FC_IO_BY_R_SKIP_NCMIRRORNumber of megabytes read from disk for IO requests that bypass FlashCache as the IO is on non-primary, non-active secondary mirror
FC large write MB due to cache hintoracle.exadata.FC_IO_BY_W_LG_CHINTNumber of megabytes used for large writes to flash cache due to cache hint
FC data aging large writes MBoracle.exadata.FC_IO_BY_W_LG_DTAGENumber of megabytes used for data aging large writes to flash cache
FC media recovery large writes MBoracle.exadata.FC_IO_BY_W_LG_MRCVNumber of megabytes used for media recovery large writes to flash cache
Bypass written MB due to not mirrored IOoracle.exadata.FC_IO_BY_W_SKIP_NCMIRRORNumber of megabytes written to disk for IO requests that bypass FlashCache as the IO is on non-primary, non-active secondary mirror
FC keep pool read IOPS missedoracle.exadata.FC_IO_RQKEEP_R_MISS_SECNumber of read requests per second for keep objects which did not find all data in FlashCache
FC keep pool read IOPSoracle.exadata.FC_IO_RQKEEP_R_SECNumber of read requests per second for keep objects from FlashCache
FC keep pool read IOPS resulting in bypassoracle.exadata.FC_IO_RQKEEP_R_SKIP_SECNumber of read requests per second for keep objects that bypass FlashCache
FC keep pool read IOPS which populated dataoracle.exadata.FC_IO_RQKEEP_W_SECNumber of requests per second for keep objects which resulted in FlashCache being populated with data
FlashCache to HDD write IOPSoracle.exadata.FC_IO_RQ_DISK_WRITE_SECNumber of requests per second written from flash cache to hard disks
Metric nameMetric keyDescription
Background SIO CPU time used (us/sec)oracle.exadata.SIO_BG_CPU_SECCPU time used by background smart IO per second
Foreground SIO CPU time used (us/sec)oracle.exadata.SIO_FG_CPU_SECCPU time used by foreground smart IO per second
Metric nameMetric keyDescription
Sender-side ACK timer expiry countoracle.exadata.EXW_ROCE_LOCAL_ACK_TIMEOUT_ERRNetwork interface sender-side ACK timer expiry count
Pause frames on the RoCE laneoracle.exadata.EXW_ROCE_PAUSENumber of pause frames on the RoCE lane
Received RNR NAK packetsoracle.exadata.EXW_ROCE_RNR_NAK_RETRY_ERRNumber of received RNR NAK packets
RX MBytes by the RoCE laneoracle.exadata.EXW_ROCE_RX_BYNumber of bytes received by the RoCE lane
RX MBps by the RoCE laneoracle.exadata.EXW_ROCE_RX_BY_SECNumber of bytes per second received by the RoCE lane
TX MBytes by the RoCE laneoracle.exadata.EXW_ROCE_TX_BYNumber of bytes transmitted by the RoCE lane
TX MBps by the RoCE laneoracle.exadata.EXW_ROCE_TX_BY_SECNumber of bytes per second transmitted by the RoCE lane
Metric nameMetric keyDescription
FlashCache IO MBpsoracle.exadata.CT_FC_IO_BY_SECNumber of megabytes of I/O per second for this category to flash cache
FlashDisks IO Mbpsoracle.exadata.CT_FD_IO_BY_SECNumber of megabytes of I/O per second for this category to flash disks
Metric nameMetric keyDescription
IOPS with no data returnedoracle.exadata.CL_IO_RQ_NODATA_SECNumber of IO requests that did not return data per second
Exadata Run Queue Lengthoracle.exadata.CL_RUNQAverage number (over the preceding minute) of processes in the Linux run queue marked running or uninterruptible (from /proc/loadavg).
Metric nameMetric keyDescription
FlashCache MB allocatedoracle.exadata.PDB_FC_BY_ALLOCATEDNumber of megabytes allocated in flash cache for this pluggable database
FlashCache IO MBpsoracle.exadata.PDB_FC_IO_BY_SECNumber of megabytes of I/O per second for this pluggable database to flash cache
FC large request IOPSoracle.exadata.PDB_FC_IO_RQ_LG_SECNumber of large IO requests issued by this pluggable database to flash cache per second
FC small request IOPSoracle.exadata.PDB_FC_IO_RQ_SM_SECNumber of small IO requests issued by this pluggable database to flash cache per second
FD large request IOPSoracle.exadata.PDB_FD_IO_RQ_LG_SECNumber of large IO requests issued by this pluggable database to flash disks per second
FD small request IOPSoracle.exadata.PDB_FD_IO_RQ_SM_SECNumber of small IO requests issued by this pluggable database to flash disks per second
FD large RW latency rate (us/req)oracle.exadata.PDB_FD_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request by this pluggable database from flash disks
FD small RW latency rate (us/req)oracle.exadata.PDB_FD_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request by this pluggable database from flash disks
IORM wait /req for large requests (avg)oracle.exadata.PDB_FD_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to flash disks by this pluggable database
IORM wait /req for small requests (avg)oracle.exadata.PDB_FD_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to flash disks by this pluggable database
HDD large request IOPSoracle.exadata.PDB_IO_RQ_LG_SECNumber of large IO requests issued by this pluggable database to hard disks per second
HDD small request IOPSoracle.exadata.PDB_IO_RQ_SM_SECNumber of small IO requests issued by this pluggable database to hard disks per second
HDD large RW latency rate (us/req)oracle.exadata.PDB_IO_TM_LG_RQThe rate which is the average latency of reading or writing large blocks per request by this pluggable database from hard disks
HDD small RW latency rate (us/req)oracle.exadata.PDB_IO_TM_SM_RQThe rate which is the average latency of reading or writing small blocks per request by this pluggable database from hard disks
IORM wait /req for large requests (avg)oracle.exadata.PDB_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to hard disks by this pluggable database
IORM wait /req for small requests (avg)oracle.exadata.PDB_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to hard disks by this pluggable database
Metric nameMetric keyDescription
RX MBps on InfiniBand interfacesoracle.exadata.N_HCA_MB_RCV_SECNumber of megabytes received by InfiniBand interfaces per second
TX MBps on InfiniBand interfacesoracle.exadata.N_HCA_MB_TRANS_SECNumber of megabytes transmitted by InfiniBand interfaces per second
InfiniBand RX port MBpsoracle.exadata.N_IB_MB_RCV_SECNumber of megabytes received by an InfiniBand port per second
InfiniBand TX port MBpsoracle.exadata.N_IB_MB_TRANS_SECNumber of megabytes transmitted by an InfiniBand port per second
InfiniBand RX port utilizationoracle.exadata.N_IB_UTIL_RCVPercentage of an InfiniBand port capacity utilized for receiving data
InfiniBand TX port utilizationoracle.exadata.N_IB_UTIL_TRANSPercentage of an InfiniBand port capacity utilized for transmitting data
Metric nameMetric keyDescription
RDMA TX MBps droppedoracle.exadata.N_MB_RDMA_DROP_SECNumber of megabytes dropped during RDMA transmission per second to a particular host
RX MBps from hostoracle.exadata.N_MB_RECEIVED_SECNumber of megabytes per second received from a particular host
TX MBps to hostoracle.exadata.N_MB_SENT_SECNumber of megabytes transmitted per second to a particular host
Metric nameMetric keyDescription
FC large request IOPSoracle.exadata.CLU_FC_IO_RQ_LG_SECNumber of large IO requests issued to flash cache per second by this cluster
FlashCache IOPSoracle.exadata.CLU_FC_IO_RQ_SECNumber of IO requests issued to flash cache per second by this cluster
FC small request IOPSoracle.exadata.CLU_FC_IO_RQ_SM_SECNumber of small IO requests issued to flash cache per second by this cluster
FlashDisks IO load (avg)oracle.exadata.CLU_FD_IO_LOADAverage I/O load for flash disks from this cluster
FD large request IOPSoracle.exadata.CLU_FD_IO_RQ_LG_SECNumber of large IO requests issued to flash disks per second by this cluster
FD small request IOPSoracle.exadata.CLU_FD_IO_RQ_SM_SECNumber of small IO requests issued to flash disks per second by this cluster
FD RW latency (cumulative)oracle.exadata.CLU_FD_IO_TMFor this cluster, the cumulative latency for block read or write requests from flash disks
FD large RW latency (cumulative)oracle.exadata.CLU_FD_IO_TM_LGFor this cluster, the cumulative latency for large block read or write requests from flash disks
FD large RW latency rate (us/req)oracle.exadata.CLU_FD_IO_TM_LG_RQFor this cluster, the average latency for each large block read or write request from flash disks
FD RW latency rate (us/req)oracle.exadata.CLU_FD_IO_TM_RQFor this cluster, the average latency for each block read or write request from flash disks
FD small RW latency (cumulative)oracle.exadata.CLU_FD_IO_TM_SMFor this cluster, the cumulative latency for small block read or write requests from flash disks
FD small RW latency rate (us/req)oracle.exadata.CLU_FD_IO_TM_SM_RQFor this cluster, the average latency for each small block read or write request from flash disks
Flash utilization by large requestsoracle.exadata.CLU_FD_IO_UTIL_LGPercentage of flash resources utilized by large requests from this cluster
Flash utilization by small requestsoracle.exadata.CLU_FD_IO_UTIL_SMPercentage of flash resources utilized by small requests from this cluster
IORM wait for large requestsoracle.exadata.CLU_FD_IO_WT_LGIORM wait time for large IO requests issued to flash disks by this cluster
IORM wait /req for large requests (avg)oracle.exadata.CLU_FD_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to flash disks by this cluster
IORM wait for small requestsoracle.exadata.CLU_FD_IO_WT_SMIORM wait time for small IO requests issued to flash disks by this cluster
IORM wait /req for small requests (avg)oracle.exadata.CLU_FD_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to flash disks by this cluster
Hard disks IO load (avg)oracle.exadata.CLU_IO_LOADAverage I/O load for hard disks from this cluster
HDD large request IOPSoracle.exadata.CLU_IO_RQ_LG_SECNumber of large IO requests issued to hard disks per second by this cluster
HDD small request IOPSoracle.exadata.CLU_IO_RQ_SM_SECNumber of small IO requests issued to hard disks per second by this cluster
HDD large RW latency (cumulative)oracle.exadata.CLU_IO_TM_LGFor this cluster, the cumulative latency for large block read or write requests from hard disks
HDD large RW latency rate (us/req)oracle.exadata.CLU_IO_TM_LG_RQFor this cluster, the average latency for each large block read or write request from hard disks
HDD small RW latency (cumulative)oracle.exadata.CLU_IO_TM_SMFor this cluster, the cumulative latency for small block read or write requests from hard disks
HDD small RW latency rate (us/req)oracle.exadata.CLU_IO_TM_SM_RQFor this cluster, the average latency for each small block read or write request from hard disks
IORM wait for large requestsoracle.exadata.CLU_IO_WT_LGIORM wait time for large IO requests issued to hard disks by this cluster
IORM wait /req for large requests (avg)oracle.exadata.CLU_IO_WT_LG_RQAverage IORM wait time per request for large IO requests issued to hard disks by this cluster
IORM wait for small requestsoracle.exadata.CLU_IO_WT_SMIORM wait time for small IO requests issued to hard disks by this cluster
IORM wait /req for small requests (avg)oracle.exadata.CLU_IO_WT_SM_RQAverage IORM wait time per request for small IO requests issued to hard disks by this cluster
Metric nameMetric keyDescription
Unflushed MB on keep pooloracle.exadata.FC_BYKEEP_DIRTYNumber of megabytes unflushed for keep objects on FlashCache
OLTP keep pool MBoracle.exadata.FC_BYKEEP_OLTPNumber of megabytes for OLTP keep objects in flash cache
Pushed out MB due to keep pool limitsoracle.exadata.FC_BYKEEP_OVERWRNumber of megabytes pushed out of the FlashCache because of space limit for keep objects
Pushed out MBps due to keep pool limitsoracle.exadata.FC_BYKEEP_OVERWR_SECNumber of megabytes per second pushed out of the FlashCache because of space limit for keep objects
Allocated MB for unflushed data in FCoracle.exadata.FC_BY_ALLOCATED_DIRTYNumber of megabytes allocated for unflushed data in flash cache
Unflushed MB in FlashCacheoracle.exadata.FC_BY_DIRTYNumber of unflushed megabytes in FlashCache
Unflushed MB due to disk not accessibleoracle.exadata.FC_BY_STALE_DIRTYNumber of unflushed megabytes in FlashCache which cannot be flushed because cached disks are not accessible
Used MB on FlashCacheoracle.exadata.FC_BY_USEDNumber of megabytes used on FlashCache
FlashCache IO errorsoracle.exadata.FC_IO_ERRSNumber of IO errors on FlashCache
Metric nameMetric keyDescription
Flash utilizationoracle.exadata.CG_FD_IO_UTILPercentage of flash resources utilized by this consumer group
Flash utilization by large requestsoracle.exadata.CG_FD_IO_UTIL_LGPercentage of flash resources utilized by large requests from this consumer group
Flash utilization by small requestsoracle.exadata.CG_FD_IO_UTIL_SMPercentage of flash resources utilized by small requests from this consumer group
Disk utilization by large requestsoracle.exadata.CG_IO_UTIL_LGPercentage of disk resources utilized by large requests from this consumer group
Disk utilization by small requestsoracle.exadata.CG_IO_UTIL_SMPercentage of disk resources utilized by small requests from this consumer group
Metric nameMetric keyDescription
FlashCache IO MBpsoracle.exadata.CLU_FC_IO_BY_SECNumber of megabytes of I/O per second to flash cache by this cluster
FlashDisks IO Mbpsoracle.exadata.CLU_FD_IO_BY_SECNumber of megabytes of I/O per second to flash disks by this cluster
Flash utilizationoracle.exadata.CLU_FD_IO_UTILPercentage of flash resources utilized by this cluster
Hard disks IO MBpsoracle.exadata.CLU_IO_BY_SECNumber of megabytes of I/O per second to hard disks by this cluster
Disk utilization by large requestsoracle.exadata.CLU_IO_UTIL_LGPercentage of disk resources utilized by large requests from this cluster
Disk utilization by small requestsoracle.exadata.CLU_IO_UTIL_SMPercentage of disk resources utilized by small requests from this cluster
Metric nameMetric keyDescription
File system space utilizationoracle.exadata.DS_FSUTPercentage of total space on this file system that is currently used
Metric nameMetric keyDescription
Memory available for smart scansoracle.exadata.EXW_CELLMEM_CELL_AVAILMemory available for smart scans
Memory % available for smart scansoracle.exadata.EXW_CELLMEM_CELL_AVAIL_PCTPercentage of memory available for smart scans
Memory used/reserved by CELLSRVoracle.exadata.EXW_CELLMEM_CELL_CELLSRVMemory used/reserved by CELLSRV
Kernel memory used by CELLSRVoracle.exadata.EXW_CELLMEM_CELL_KNLEstimated kernel memory used by CELLSRV
Max memory limit for Exadata softwareoracle.exadata.EXW_CELLMEM_CELL_MAXMaximum memory limit for Exadata software
Memory used/reserved by cell offload serversoracle.exadata.EXW_CELLMEM_CELL_OFFLOADMemory used/reserved by cell offload servers
Physical memory available in the systemoracle.exadata.EXW_CELLMEM_OS_AVAILPhysical memory available in the system
Physical memory % available in the systemoracle.exadata.EXW_CELLMEM_OS_AVAIL_PCTPercentage of physical memory available in the system
Memory used by the OS kerneloracle.exadata.EXW_CELLMEM_OS_KNLMemory used by the OS kernel
System memory totaloracle.exadata.EXW_CELLMEM_OS_TOTALTotal amount of memory in the system
Memory used by user-level processesoracle.exadata.EXW_CELLMEM_OS_USRMemory used by user-level processes
XRMEM cache MB allocated totaloracle.exadata.XRM_BY_ALLOCATEDNumber of megabytes allocated in XRMEM cache
Non-blocked sends blocked by congestionoracle.exadata.EXW_RDS_CONG_SEND_BLOCKEDNumber of non-blocked sends that were blocked due to destination congestion
Blocked sends not completedoracle.exadata.EXW_RDS_CONG_SEND_ERRORNumber of blocked sends not completed due to destination congestion
Times the 1MB pool reached maximum capacityoracle.exadata.EXW_RDS_IB_MR_1M_POOL_DEPLETEDNumber of times the 1MB pool reached maximum capacity
Times the 8KB pool reached maximum capacityoracle.exadata.EXW_RDS_IB_RDMA_MR_8K_POOL_DEPLETEDNumber of times the 8KB pool reached maximum capacity
Send requests exceeding 500ms to completeoracle.exadata.EXW_RDS_IB_TX_STALLEDNumber of network send requests exceeding 500ms to complete
Metric nameMetric keyDescription
GD large read MBoracle.exadata.GD_IO_BY_R_LGNumber of megabytes read in large blocks from a grid disk
GD large read MBpsoracle.exadata.GD_IO_BY_R_LG_SECNumber of megabytes read in large blocks per second from a grid disk
GD Scrubbing job read MBoracle.exadata.GD_IO_BY_R_SCRUBNumber of megabytes read from a grid disk by the scrubbing job
GD Scrubbing job read MBpsoracle.exadata.GD_IO_BY_R_SCRUB_SECNumber of megabytes read per second from a grid disk by the scrubbing job
GD small read MBoracle.exadata.GD_IO_BY_R_SMNumber of megabytes read in small blocks from a grid disk
GD small read MBpsoracle.exadata.GD_IO_BY_R_SM_SECNumber of megabytes read in small blocks per second from a grid disk
GD large write MBoracle.exadata.GD_IO_BY_W_LGNumber of megabytes written in large blocks to a grid disk
GD large write MBpsoracle.exadata.GD_IO_BY_W_LG_SECNumber of megabytes written in large blocks per second to a grid disk
GD small write MBoracle.exadata.GD_IO_BY_W_SMNumber of megabytes written in small blocks to a grid disk
GD small write MBpsoracle.exadata.GD_IO_BY_W_SM_SECNumber of megabytes written in small blocks per second to a grid disk
Grid disk IO errorsoracle.exadata.GD_IO_ERRSNumber of IO errors on a grid disk
Grid disk IO errors per minuteoracle.exadata.GD_IO_ERRS_MINNumber of IO errors on a grid disk per minute
Grid disk IO errors scrubbedoracle.exadata.GD_IO_ERRS_SCRUBNumber of IO errors hit by the scrubbing job on a grid disk
Read retries for an NVM grid diskoracle.exadata.GD_NVM_READ_RETRIESNumber of read retries for a non-volatile memory (NVM) grid disk
Physical space MB allocated for grid diskoracle.exadata.GD_SP_BY_ALLOCATEDAllocated physical space for grid disk in bytes
Partial IO bytes returnedoracle.exadata.GD_SP_IO_BY_PARTIALBytes returned by partial IOs
Partial IO bytes returned rate (kBps)oracle.exadata.GD_SP_IO_BY_PARTIAL_SECBytes returned by partial IOs per second
Sparse bytes redirectedoracle.exadata.GD_SP_IO_BY_REDIRECTEDSparse bytes redirected to original data block
Sparse kBps redirected rate (kBps)oracle.exadata.GD_SP_IO_BY_REDIRECTED_SECSparse bytes redirected to original data block per second
Partial data return requests IOPSoracle.exadata.GD_SP_IO_RQ_PARTIAL_SECNumber of IO requests that returned partial data per second
Allocated physical space %oracle.exadata.GD_SP_PRCT_ALLOCATEDAllocated physical space for grid disk by percentage
Metric nameMetric keyDescription
Columnar keep pool used MBoracle.exadata.FC_COL_BYKEEP_USEDNumber of megabytes used for keep objects in Columnar FlashCache
Read MB for keeporacle.exadata.FC_COL_IO_BYKEEP_RNumber of megabytes read from Columnar FlashCache for keep objects
Read MBps for keeporacle.exadata.FC_COL_IO_BYKEEP_R_SECNumber of megabytes read per second from Columnar FlashCache for keep objects
Read MB from Columnar FCoracle.exadata.FC_COL_IO_BY_RNumber of megabytes that were read from Columnar FlashCache
Eligible MB to read from Columnar FCoracle.exadata.FC_COL_IO_BY_R_ELIGIBLENumber of megabytes eligible to read from Columnar FlashCache
Read MBps from Columnar FCoracle.exadata.FC_COL_IO_BY_R_SECNumber of megabytes per second that were read from Columnar FlashCache
MB saved by reads from Columnar FCoracle.exadata.FC_COL_IO_BY_SAVEDNumber of megabytes saved by reads from Columnar FlashCache
MBps saved by reads from Columnar FCoracle.exadata.FC_COL_IO_BY_SAVED_SECNumber of megabytes saved per second by reads from Columnar FlashCache
Population columnar FC writes MB due to read missoracle.exadata.FC_COL_IO_BY_W_POPULATENumber of megabytes that are population writes into Columnar FlashCache due to read miss
Population columnar FC writes MBps due to read missoracle.exadata.FC_COL_IO_BY_W_POPULATE_SECNumber of megabytes per second that are population writes into Columnar FlashCache due to read miss
Read IOPS for keeporacle.exadata.FC_COL_IO_RQKEEP_R_SECNumber of requests read per second for keep objects from Columnar FlashCache
Eligible read IOPS from Columnar FCoracle.exadata.FC_COL_IO_RQ_R_ELIGIBLE_SECNumber of reads per second eligible for Columnar FlashCache
Population write IOPS due to read missoracle.exadata.FC_COL_IO_RQ_W_POPULATE_SECNumber of requests per second that are population writes into Columnar FlashCache due to read miss
Metric nameMetric keyDescription
System load 1moracle.exadata.OS_CPU_LOAD1System load average over the last 1 minute
System load 5moracle.exadata.OS_CPU_LOAD5System load average over the last 5 minutes
System load 15moracle.exadata.OS_CPU_LOAD15System load average over the last 15 minutes
CPU usage %oracle.exadata.OS_CPU_PCTPercentage of CPU utilization over the time interval
Available memoryoracle.exadata.OS_MEM_BY_AVAILTotal available server memory
Free memoryoracle.exadata.OS_MEM_BY_FREETotal free server memory
Used memoryoracle.exadata.OS_MEM_BY_USEDTotal used server memory
Usable memoryoracle.exadata.OS_MEM_BY_TOTALTotal usable server memory
Swap kB availableoracle.exadata.OS_SWAP_BY_FREETotal amount of free swap space
Swap kB usedoracle.exadata.OS_SWAP_BY_USEDTotal amount of used swap space
Swap kB totaloracle.exadata.OS_SWAP_BY_TOTALTotal amount of swap space
Metric nameMetric keyDescription
Keep pool used MBoracle.exadata.FC_BYKEEP_USEDNumber of megabytes used for keep objects on FlashCache
Allocated MB in FlashCacheoracle.exadata.FC_BY_ALLOCATEDNumber of megabytes allocated in flash cache
Allocated MB for OLTP data in FCoracle.exadata.FC_BY_ALLOCATED_OLTPNumber of megabytes allocated for OLTP data in flash cache
OLTP small reads MBoracle.exadata.FC_IO_BY_RNumber of megabytes of small reads (OLTP) from flash cache
OLTP small reads MBpsoracle.exadata.FC_IO_BY_R_SECNumber of megabytes of small reads (OLTP) per second from flash cache
Bypass reads MBoracle.exadata.FC_IO_BY_R_SKIPNumber of megabytes read from disks for IO requests that bypass FlashCache
FlashCache MB writtenoracle.exadata.FC_IO_BY_WNumber of megabytes written to FlashCache
FlashCache write MBpsoracle.exadata.FC_IO_BY_W_SECNumber of megabytes per second written to FlashCache
Bypass written MBoracle.exadata.FC_IO_BY_W_SKIPNumber of megabytes written to disk for IO requests that bypass FlashCache
OLTP small read hit IOPSoracle.exadata.FC_IO_RQ_R_SECNumber of small reads (OLTP) per second satisfied from the flash cache
IOPS successfully populating FC with dataoracle.exadata.FC_IO_RQ_W_SECNumber of requests per second which resulted in FlashCache being populated with data
Metric nameMetric keyDescription
Device RX rate MBpsoracle.exadata.OS_IO_BY_R_SECNumber of bytes read per second from the device
Device TX rate MBpsoracle.exadata.OS_IO_BY_W_SECNumber of bytes written per second to the device
Device reads completed (req/s)oracle.exadata.OS_IO_RQ_R_SECNumber of read requests completed per second for the device
Device IO request size (avg)oracle.exadata.OS_IO_RQ_SZAverage size of IO requests issued to the device
Device writes completed (req/s)oracle.exadata.OS_IO_RQ_W_SECNumber of write requests completed per second for the device
Device IO request service time (avg)oracle.exadata.OS_IO_TM_RQAverage service time of the IO requests issued to the device
Device IO requests time percentageoracle.exadata.OS_IO_UTIL_PCTPercentage of time during which I/O requests were issued to the device
Device IO request latency (avg)oracle.exadata.OS_IO_WT_RQAverage latency of the IO requests issued to the device
Device read request latency (avg)oracle.exadata.OS_IO_WT_R_RQAverage latency of read requests from the device
Device write request latency (avg)oracle.exadata.OS_IO_WT_W_RQAverage latency of write requests to the device
Metric nameMetric keyDescription
Exadata Run Queue Lengthoracle.exadata.DS_RUNQAverage number (over the preceding minute) of processes in the Linux run queue marked running or uninterruptible (from /proc/loadavg).
Metric nameMetric keyDescription
Host TX MB droppedoracle.exadata.N_MB_DROPNumber of megabytes droped during transmission to a particular host
Host TX MBps droppedoracle.exadata.N_MB_DROP_SECNumber of megabytes droped during transmission per second to a particular host
RDMA TX MB droppedoracle.exadata.N_MB_RDMA_DROPNumber of megabytes dropped during RDMA transmission to a particular host
RX MB from hostoracle.exadata.N_MB_RECEIVEDNumber of megabytes received from a particular host
Resent MB to hostoracle.exadata.N_MB_RESENTNumber of megabytes resent to a particular host
Resent MBps to hostoracle.exadata.N_MB_RESENT_SECNumber of megabytes resent per second to a particular host
TX MB to hostoracle.exadata.N_MB_SENTNumber of megabytes transmitted to a particular host
RDMA TX retry latencyoracle.exadata.N_RDMA_RETRY_TMLatency of the retry actions during RDMA transmission to a particular host
Metric nameMetric keyDescription
Average rds-ping latencyoracle.exadata.EXW_RDS_PINGAverage rds-ping latency
Average rds-ping latency on lane 0oracle.exadata.EXW_RDS_PING_0Average rds-ping latency on lane 0
Metric nameMetric keyDescription
Cell disk unflushed volume cachedoracle.exadata.CD_BY_FC_DIRTYNumber of unflushed megabytes cached in FLASHCACHE on a cell disk
CD large read MBoracle.exadata.CD_IO_BY_R_LGNumber of megabytes read in large blocks from a cell disk
CD large read MBpsoracle.exadata.CD_IO_BY_R_LG_SECNumber of megabytes read in large blocks per second from a cell disk
CD Scrubbing job read MBoracle.exadata.CD_IO_BY_R_SCRUBNumber of megabytes read from a cell disk by the scrubbing job
CD Scrubbing job read MBpsoracle.exadata.CD_IO_BY_R_SCRUB_SECNumber of megabytes read per second from a cell disk by the scrubbing job
CD small read MBoracle.exadata.CD_IO_BY_R_SMNumber of megabytes read in small blocks from a cell disk
CD small read MBpsoracle.exadata.CD_IO_BY_R_SM_SECNumber of megabytes read in small blocks per second from a cell disk
CD large write MBoracle.exadata.CD_IO_BY_W_LGNumber of megabytes written in large blocks to a cell disk
CD large write MBpsoracle.exadata.CD_IO_BY_W_LG_SECNumber of megabytes written in large blocks per second to a cell disk
CD small write MBoracle.exadata.CD_IO_BY_W_SMNumber of megabytes written in small blocks to a cell disk
CD small write MBpsoracle.exadata.CD_IO_BY_W_SM_SECNumber of megabytes written in small blocks per second to a cell disk
Cell disk IO errors scrubbedoracle.exadata.CD_IO_ERRS_SCRUBNumber of IO errors hit by the scrubbing job on a cell disk
Cell disk IO loadoracle.exadata.CD_IO_LOADAverage I/O load for the cell disk
CD large read IOPSoracle.exadata.CD_IO_RQ_R_LG_SECNumber of requests to read large blocks per second from a cell disk
CD scrubbing job read IOPSoracle.exadata.CD_IO_RQ_R_SCRUB_SECNumber of requests to read per second from a cell disk by the scrubbing job
CD small read IOPSoracle.exadata.CD_IO_RQ_R_SM_SECNumber of requests to read small blocks per second from a cell disk
CD large write IOPSoracle.exadata.CD_IO_RQ_W_LG_SECNumber of requests to write large blocks per second to a cell disk
CD small write IOPSoracle.exadata.CD_IO_RQ_W_SM_SECNumber of requests to write small blocks per second to a cell disk
Small request service timeoracle.exadata.CD_IO_ST_RQAverage service time per request for small IO requests to a cell disk
CD large read latency rate (us/req)oracle.exadata.CD_IO_TM_R_LG_RQAverage latency of reading large blocks per request to a cell disk
CD small read latency rate (us/req)oracle.exadata.CD_IO_TM_R_SM_RQAverage latency of reading small blocks per request from a cell disk
CD small write latency rate (us/req)oracle.exadata.CD_IO_TM_W_SM_RQAverage latency of writing small blocks per request to a cell disk
Cell disk utilizationoracle.exadata.CD_IO_UTILPercentage of disk resources utilized for the cell disk
Cell disk utilization by large requestsoracle.exadata.CD_IO_UTIL_LGPercentage of disk resources utilized by large requests for the cell disk
Cell disk utilization by small requestsoracle.exadata.CD_IO_UTIL_SMPercentage of disk resources utilized by small requests for the cell disk
Metric nameMetric keyDescription
Unflushed cached MB for a grid diskoracle.exadata.GD_BY_FC_DIRTYNumber of unflushed megabytes cached in FLASHCACHE for a grid disk
GD large read IOPSoracle.exadata.GD_IO_RQ_R_LG_SECNumber of requests to read large blocks per second from a grid disk
GD scrubbing job read IOPSoracle.exadata.GD_IO_RQ_R_SCRUB_SECNumber of requests to read per second from a grid disk by the scrubbing job
GD small read IOPSoracle.exadata.GD_IO_RQ_R_SM_SECNumber of requests to read small blocks per second from a grid disk
GD large write IOPSoracle.exadata.GD_IO_RQ_W_LG_SECNumber of requests to write large blocks per second to a grid disk
GD small write IOPSoracle.exadata.GD_IO_RQ_W_SM_SECNumber of requests to write small blocks per second to a grid disk
Metric nameMetric keyDescription
Active secondary reads MB satisfied from FCoracle.exadata.FC_IO_BY_R_ACTIVE_SECONDARYNumber of megabytes for active secondary reads satisfied from flash cache
Active secondary reads MB not satisfied from FCoracle.exadata.FC_IO_BY_R_ACTIVE_SECONDARY_MISSNumber of megabytes for active secondary reads not satisfied from flash cache
Active secondary read MBps not satisfied from FCoracle.exadata.FC_IO_BY_R_ACTIVE_SECONDARY_MISS_SECNumber of megabytes per second for active secondary reads not satisfied from flash cache
Active secondary read MBps satisfied from FCoracle.exadata.FC_IO_BY_R_ACTIVE_SECONDARY_SECNumber of megabytes per second for active secondary reads satisfied from flash cache
Disk writer MB readoracle.exadata.FC_IO_BY_R_DISK_WRITERNumber of megabytes read from flash cache by disk writer
Disk writer MBps readoracle.exadata.FC_IO_BY_R_DISK_WRITER_SECNumber of megabytes per second read from flash cache by disk writer
DW large reads MB from FCoracle.exadata.FC_IO_BY_R_DWNumber of megabytes of large reads (DW) from flash cache
DW large reads MBps from FCoracle.exadata.FC_IO_BY_R_DW_SECNumber of megabytes of large reads (DW) per second from flash cache
OLTP small reads MB due to keep missesoracle.exadata.FC_IO_BY_R_MISSNumber of megabytes of small reads (OLTP) from disks because some of the requested data was not in flash cache
DW large reads MB due to keep missesoracle.exadata.FC_IO_BY_R_MISS_DWNumber of megabytes of large reads (DW) from disks because some of the requested data was not in flash cache
DW large reads MBps due to keep missesoracle.exadata.FC_IO_BY_R_MISS_DW_SECNumber of megabytes of large reads (DW) per second from disks because some of the requested data was not in flash cache
OLTP small reads MBps due to keep missesoracle.exadata.FC_IO_BY_R_MISS_SECNumber of megabytes of small reads (OLTP) per second from disks because some of the requested data was not in flash cache
Bypass reads MB due to heavy loadoracle.exadata.FC_IO_BY_R_SKIP_FC_THROTTLENumber of megabytes read from disk for IO requests that bypass FlashCache due to heavy load on FlashCache
Bypass reads MBps due to heavy loadoracle.exadata.FC_IO_BY_R_SKIP_FC_THROTTLE_SECNumber of megabytes read per second from disk for IO requests that bypass FlashCache due to heavy load on FlashCache
Bypass reads MB due to large IO sizeoracle.exadata.FC_IO_BY_R_SKIP_LGNumber of megabytes read from disk for IO requests that bypass FlashCache due to the large IO size
Bypass reads MBps due to large IO sizeoracle.exadata.FC_IO_BY_R_SKIP_LG_SECNumber of megabytes read per second from disk for IO requests that bypass FlashCache due to the large IO size
Bypass reads MBpsoracle.exadata.FC_IO_BY_R_SKIP_SECNumber of megabytes read from disks per second for IO requests that bypass FlashCache
Disk writer MB writtenoracle.exadata.FC_IO_BY_W_DISK_WRITERNumber of megabytes written to hard disks by disk writer
Disk writer MBps writtenoracle.exadata.FC_IO_BY_W_DISK_WRITER_SECNumber of megabytes per second written to hard disks by disk writer
First write MB into FlashCacheoracle.exadata.FC_IO_BY_W_FIRSTNumber of megabytes that are first writes into flash cache
First write MBps into FlashCacheoracle.exadata.FC_IO_BY_W_FIRST_SECNumber of megabytes per second that are first writes into flash cache
FC metadata writes MBoracle.exadata.FC_IO_BY_W_METADATANumber of megabytes that are flash cache metadata writes
FC metadata writes MBpsoracle.exadata.FC_IO_BY_W_METADATA_SECNumber of megabytes per second that are flash cache metadata writes
FC overwrite MBoracle.exadata.FC_IO_BY_W_OVERWRITENumber of megabytes that are overwrites into flash cache
FC overwrite MBpsoracle.exadata.FC_IO_BY_W_OVERWRITE_SECNumber of megabytes per second that are overwrites into flash cache
FC population writes MB due to read missoracle.exadata.FC_IO_BY_W_POPULATENumber of megabytes that are population writes into flash cache due to read miss
FC population writes MBps due to read missoracle.exadata.FC_IO_BY_W_POPULATE_SECNumber of megabytes per second that are population writes into flash cache due to read miss
Bypass written MB due to heavy loadoracle.exadata.FC_IO_BY_W_SKIP_FC_THROTTLENumber of megabytes written to disk for IO requests that bypass FlashCache due to heavy load on FlashCache
Bypass write MBps due to heavy loadoracle.exadata.FC_IO_BY_W_SKIP_FC_THROTTLE_SECNumber of megabytes written per second to disk for IO requests that bypass FlashCache due to heavy load on FlashCache
Bypass written MB due to large IO sizeoracle.exadata.FC_IO_BY_W_SKIP_LGNumber of megabytes written to disk for IO requests that bypass FlashCache due to the large IO size
Bypass write MBps due to large IO sizeoracle.exadata.FC_IO_BY_W_SKIP_LG_SECNumber of megabytes written per second to disk for IO requests that bypass FlashCache due to the large IO size
Bypass write MBpsoracle.exadata.FC_IO_BY_W_SKIP_SECNumber of megabytes written to disk per second for IO requests that bypass FlashCache
Active secondary read IOPS not satisfied from FCoracle.exadata.FC_IO_RQ_R_ACTIVE_SECONDARY_MISS_SECNumber of requests per second for active secondary reads not satisfied from flash cache
Active secondary read IOPS satisfied from FCoracle.exadata.FC_IO_RQ_R_ACTIVE_SECONDARY_SECNumber of requests per second for active secondary reads satisfied from flash cache
Disk writer FC read IOPSoracle.exadata.FC_IO_RQ_R_DISK_WRITER_SECNumber of requests per second read from flash cache by disk writer
DW large read hit IOPSoracle.exadata.FC_IO_RQ_R_DW_SECNumber of large reads (DW) per second satisfied from the flash cache
DW large read miss IOPSoracle.exadata.FC_IO_RQ_R_MISS_DW_SECNumber of large reads (DW) per second that did not find all data in flash cache
OLTP small read miss IOPSoracle.exadata.FC_IO_RQ_R_MISS_SECNumber of small reads (OLTP) per second that did not find all data in flash cache
Bypass read IOPS due to heavy loadoracle.exadata.FC_IO_RQ_R_SKIP_FC_THROTTLE_SECNumber of requests read from disk per second that bypassed FlashCache due to heavy load on FlashCache
Bypass read IOPS due to large IO sizeoracle.exadata.FC_IO_RQ_R_SKIP_LG_SECNumber of requests read from disk per second that bypass FlashCache due to the large IO size
Bypass read IOPSoracle.exadata.FC_IO_RQ_R_SKIP_SECNumber of requests read from disk per second that bypass FlashCache
Disk writer HDD write IOPSoracle.exadata.FC_IO_RQ_W_DISK_WRITER_SECNumber of requests per second written to hard disks by disk writer
First write into FlashCache IOPSoracle.exadata.FC_IO_RQ_W_FIRST_SECNumber of requests per second that are first writes into flash cache
FC metadata writes IOPSoracle.exadata.FC_IO_RQ_W_METADATA_SECNumber of requests per second that are flash cache metadata writes
FC overwrite IOPSoracle.exadata.FC_IO_RQ_W_OVERWRITE_SECNumber of requests per second that are overwrites into flash cache
Population FC write IOPS due to read missoracle.exadata.FC_IO_RQ_W_POPULATE_SECNumber of requests per second that are population writes into flash cache due to read miss
Bypass write IOPS due to heavy loadoracle.exadata.FC_IO_RQ_W_SKIP_FC_THROTTLE_SECNumber of requests written to disk per second that bypass FlashCache due to heavy load on FlashCache
Bypass write IOPS due to large IO sizeoracle.exadata.FC_IO_RQ_W_SKIP_LG_SECNumber of requests written to disk per second that bypass FlashCache due to the large IO size
Bypass write IOPSoracle.exadata.FC_IO_RQ_W_SKIP_SECNumber of requests written to disk per second that bypass FlashCache
Metric nameMetric keyDescription
FlashCache IOPSoracle.exadata.PDB_FC_IO_RQ_SECNumber of IO requests issued by this pluggable database to flash cache per second
FlashDisks IO Mbpsoracle.exadata.PDB_FD_IO_BY_SECNumber of megabytes of I/O per second for this pluggable database to flash disks
FlashDisks IO load (avg)oracle.exadata.PDB_FD_IO_LOADAverage I/O load from this pluggable database for flash disks
FD RW latency (cumulative)oracle.exadata.PDB_FD_IO_TMThe cumulative latency of reading or writing blocks by this pluggable database from flash disks
FD large RW latency (cumulative)oracle.exadata.PDB_FD_IO_TM_LGThe cumulative latency of reading or writing large blocks by this pluggable database from flash disks
FD RW latency rate (us/req)oracle.exadata.PDB_FD_IO_TM_RQThe rate which is the average latency of reading or writing blocks per request by this pluggable database from flash disks
FD small RW latency (cumulative)oracle.exadata.PDB_FD_IO_TM_SMThe cumulative latency of reading or writing small blocks by this pluggable database from flash disks
Flash utilizationoracle.exadata.PDB_FD_IO_UTILPercentage of flash resources utilized by this pluggable database
Flash utilization by large requestsoracle.exadata.PDB_FD_IO_UTIL_LGPercentage of flash resources utilized by large requests from this pluggable database
Flash utilization by small requestsoracle.exadata.PDB_FD_IO_UTIL_SMPercentage of flash resources utilized by small requests from this pluggable database
IORM wait for large requestsoracle.exadata.PDB_FD_IO_WT_LGIORM wait time for large IO requests issued to flash disks by this pluggable database
IORM wait for small requestsoracle.exadata.PDB_FD_IO_WT_SMIORM wait time for small IO requests issued to flash disks by this pluggable database
Hard disks IO MBpsoracle.exadata.PDB_IO_BY_SECNumber of megabytes of I/O per second for this pluggable database to hard disks
Hard disks IO load (avg)oracle.exadata.PDB_IO_LOADAverage I/O load from this pluggable database for hard disks
HDD large RW latency (cumulative)oracle.exadata.PDB_IO_TM_LGThe cumulative latency of reading or writing large blocks by this pluggable database from hard disks
HDD small RW latency (cumulative)oracle.exadata.PDB_IO_TM_SMThe cumulative latency of reading or writing small blocks by this pluggable database from hard disks
Disk utilization by large requestsoracle.exadata.PDB_IO_UTIL_LGPercentage of disk resources utilized by large requests from this pluggable database
Disk utilization by small requestsoracle.exadata.PDB_IO_UTIL_SMPercentage of disk resources utilized by small requests from this pluggable database
IORM wait for large requestsoracle.exadata.PDB_IO_WT_LGIORM wait time for large IO requests issued to hard disks by this pluggable database
IORM wait for small requestsoracle.exadata.PDB_IO_WT_SMIORM wait time for small IO requests issued to hard disks by this pluggable database
XRMEM PDB cache MB allocatedoracle.exadata.PDB_XRM_BY_ALLOCATEDNumber of megabytes allocated in XRMEM cache for this pluggable database
Cell CPU usage by population jobs %oracle.exadata.PDB_CPU_UTIL_COLFor this PDB, percentage of cell CPU resources utilized by columnar population jobs
Cell CPU usage by smart IO jobs %oracle.exadata.PDB_CPU_UTIL_SIOFor this PDB, percentage of cell CPU resources utilized by smart IO jobs
SIO jobs on cell vs sent back to DB (%)oracle.exadata.PDB_SIO_OF_PCTFor this PDB, percentage of smart IO jobs processed on the cell versus jobs sent back to the database server because the PDB exhausted its cell CPU limit
Metric nameMetric keyDescription
Ethernet RX kBpsoracle.exadata.N_NIC_KB_RCV_SECNumber of kilobytes received by Ethernet interfaces per second
Ethernet TX kBpsoracle.exadata.N_NIC_KB_TRANS_SECNumber of kilobytes transmitted by Ethernet interfaces per second
Metric nameMetric keyDescription
Cell disk IO errorsoracle.exadata.CD_IO_ERRSNumber of IO errors on a cell disk
Cell disk IO errors per minuteoracle.exadata.CD_IO_ERRS_MINNumber of IO errors on a cell disk per minute
CD large read latency (cumulative)oracle.exadata.CD_IO_TM_R_LGCumulative latency of reading large blocks from a cell disk
CD small read latency (cumulative)oracle.exadata.CD_IO_TM_R_SMCumulative latency of reading small blocks from a cell disk
CD large write latency (cumulative)oracle.exadata.CD_IO_TM_W_LGCumulative latency of writing large blocks to a cell disk
CD large write latency rate (us/req)oracle.exadata.CD_IO_TM_W_LG_RQAverage latency of writing large blocks per request to a cell disk
CD small write latency (cumulative)oracle.exadata.CD_IO_TM_W_SMCumulative latency of writing small blocks to a cell disk
Metric nameMetric keyDescription
Physical memory utilization by MSoracle.exadata.CL_MEMUT_MSPercentage of physical memory used by MS
Physical memory utilization by CELLSRVoracle.exadata.CL_MEMUT_CSPercentage of physical memory used by CELLSRV
Physical memory utilizationoracle.exadata.CL_MEMUTPercentage of total physical memory on this server that is currently used
Disk Controller Battery Temperatureoracle.exadata.CL_BBU_TEMPDisk Controller Battery Temperature
Disk Controller Battery Chargeoracle.exadata.CL_BBU_CHARGEDisk Controller Battery Charge
Swap used %oracle.exadata.CL_SWAP_USAGEPercentage of swap used
Swap read speed kBpsoracle.exadata.CL_SWAP_IN_BY_SECAmount of swap pages read in KB per second
Swap write speed kBpsoracle.exadata.CL_SWAP_OUT_BY_SECAmount of swap pages written in KB per second
CPU not idle %oracle.exadata.CL_CPUTPercentage of time over the previous minute that the system CPUs were not idle.
CPU usage by CELLSRV %oracle.exadata.CL_CPUT_CSPercentage of CPU time used by CELLSRV
CPU usage by MS %oracle.exadata.CL_CPUT_MSPercentage of CPU time used by MS
Virtual memory used by CELLSRVoracle.exadata.CL_VIRTMEM_CSAmount of virtual memory used by CELLSRV in MB
Virtual memory used by MSoracle.exadata.CL_VIRTMEM_MSAmount of virtual memory used by MS in MB
Temperature (Celsius) of the serveroracle.exadata.CL_TEMPTemperature (Celsius) of the server, provided by the BMC
Fans working on the celloracle.exadata.CL_FANSNumber of working fans on the cell
IORM objective for the celloracle.exadata.IORM_MODEI/O Resource Manager objective for the cell

FAQ

This extension does not support monitoring ExaCC (Exadata Cloud at Customer).

For more information and potential alternatives, see OCI monitoring services by Oracle. Oracle says that Metrics for Exadata database service can be emitted to the OCI monitoring services. Dynatrace's Oracle Connector Hub Signals Ingest can consume metrics from the Connector Hub. Note: this answer is a digest of the publicly available documentation; this route hasn't been tested and verified by Dynatrace.

Exadata metric keys have a self-explanatory structure. Knowing it, you will always be able to understand what specific metric represents, exactly, even if its name or description looks similar to other available metrics.

Key to deciphering Exadata metric names:

The value of the name attribute is a composite of abbreviations. The attribute value starts with an abbreviation of the object type on which the metric is defined:

CD_ (cell disk)
CG_ (IORM consumer group, database-qualified)
CL_ (cell)
CT_ (IORM category)
DB_ (IORM database-level)
FC_ (flash cache)
FL_ (flash log)
GD_ (grid disk)
IORM (Input Output Resource Management)
N_ (network, IBPORT, HOST_INTERCONNECT)
PDB_ (IORM pluggable database)
SIO_ (Smart IO)

After the abbreviation of the object type, most of the name attributes contain one of the following combinations to identify the operation:

IO_BY (I/O amount)
IO_RQ (number of I/O requests)
IO_TM (I/O latency)
IO_WT (I/O wait time)
FC_IO_BY (Flash cache I/O amount)
FC_IO_RQ (Flash cache I/O requests)
FD_IO_BY (Flash disk I/O amount)
FD_IO_RQ (Flash disk I/O requests)
FD_IO_TM (Flash disk latency)
FD_IO_UTIL (Flash disk utilization percentage)

Next, in the name could be

_R (for read) or
_W (for write).

Following that in the name attribute value there might be

_SM or _LG to identify small or
_LG to identify large blocks, respectively.

At the end of the name, there could be

_SEC to signify per seconds or
_RQ to signify per request.

For consumer group and category metrics, read or write details are omitted.

For example: CD_IO_RQ_R_SM is the number of requests to read small blocks on a cell disk. GD_IO_TM_W_LG is the microseconds of I/O latency writing large blocks on a grid disk.

Source: Exadata Database Machine User's Guide section DESCRIBE METRICDEFINITION.

You need to configure metric streams on each Exadata server you intend to monitor. Use DBMCLI utility on DB servers. Use CELLCLI utility on cell servers. Or use utilities designed to run administration commands across a number of servers (dcli, exadcli) - see Exadata Software Overview.

Metrics must be enabled for Real-Time Insight on the Exadata side. Most likely, metrics are enabled by default on your Exadata system. If they are not, enable metrics for Real-Time Insight with the command:

alter metricdefinition finegrained=enabled where finegrained=disable

You can check what metrics are enabled using command:

list metricdefinition where finegrained=enabled detail

The command returns a detailed list of metrics that are enabled for Real-Time Insight.

Related tags
ComputePythonOracleOracleInfrastructure Observability