Reference Guides for Exadata Cloud Infrastructure

Monitor Metrics for VM Cluster Resources

You can monitor the health, capacity, and performance of your VM clusters and databases with metrics, alarms, and notifications. You can use Oracle Cloud Infrastructure Console, Monitoring APIs, or Database Management APIs to view metrics.

Note: To view metrics you must have the required access as specified in an Oracle Cloud Infrastructure policy (whether you're using the Console, the REST API, or another tool). See Getting Started with Policies for information on policies.

Prerequisites for Using Metrics

The following prerequisites are required for the metrics to flow out of the VM cluster.

  1. Metrics on the VM clusters depends on Oracle Trace File Analyzer (TFA) agent. Ensure that these components are up and running. AHF version 22.2.4 or higher is required for capturing metrics from the VM clusters. To start, stop, or check the status of TFA, see Manage Oracle Trace File Analyzer.
  2. The following network configurations are required.
    1. Egress rules for outgoing traffic: The default egress rules are sufficient to enable the required network path : For more information, see Default Security List .If you have blocked the outgoing traffic by modifying the default egress rules on your Virtual Cloud Network(VCN), you will need to revert the settings to allow outgoing traffic. The default egress rule allowing outgoing traffic (as shown in the Rules Required for both Client and Backup Networks ) is as follows:
      • Stateless: No (all rules must be stateful)
      • Destination Type: CIDR
      • Destination CIDR: All <region> Services in Oracle Services Network
      • IP Protocol: 443 (HTTPS)
    2. Public IP or Service Gateway: The compute instance must have either a public IP address or a service gateway to be able to send compute instance metrics to the Monitoring service.

      If the instance does not have a public IP address, set up a service gateway on the virtual cloud network (VCN). The service gateway lets the instance send compute instance metrics to the Monitoring service without the traffic going over the internet. Here are special notes for setting up the service gateway to access the Monitoring service:

      1. When creating the service gateway, enable the service label called All <region> Services in Oracle Services Network. It includes the Monitoring service.
      2. When setting up routing for the subnet that contains the instance, set up a route rule with Target Type set to Service Gateway, and the Destination Service set to All <region> Services in Oracle Services Network.

        For detailed instructions, see Access to Oracle Services: Service Gateway.

View Metrics for VM Cluster

Perform the following steps to view the metrics for Guest VMs using the console.

  1. Open the navigation menu. Click Oracle Database, then click Exadata on Oracle Public Cloud.
  2. Choose your Compartment. A list of VM clusters is displayed.
  3. In the list of VM clusters, click the VM cluster for which you want to view the metrics. Details of the VM cluster you selected are displayed.
  4. In the Resources section, click Metrics. A chart for each metrics is displayed.
  5. By default, the metrics for the last one hour are displayed.
  6. If you want to change the interval, select the required start time and end time. Alternatively, you can select the interval from the Quick Selects drop down menu. The metrics are refreshed immediately for the selected interval.
  7. For each metric, you can choose the interval and statistic independently.
    • Interval - The time period for which the metric is calculated.
    • Statistic - The mathematical method by which the metric is calculated.
  8. For each metric, you can choose the following options from the 'Options' drop down menu.
    • View Query in Metrics Explorer

    • Copy Chart URL

    • Copy Query (MQL)

    • Create an Alarm on this Query
    • Table View

For Detailed information on various options for viewing the metrics chart, see Viewing Default Metric Charts.

View Metrics for a Database

Perform the following steps to view the metrics for a database using the console.

  1. Open the navigation menu. Click Oracle Database, then click Exadata on Oracle Public Cloud.
  2. Choose your Compartment. A list of VM clusters is displayed.
  3. In the list of VM clusters, click the VM cluster that contains the database for which you want to view the metrics. Details of the VM cluster you selected are displayed.
  4. In the list of databases, click the database for which you want to view the metrics.
  5. In the Resources section, click Metrics. A chart for each metrics is displayed.
  6. By default, the metrics for the last one hour are displayed.
  7. If you want to change the interval, select the required start time and end time. Alternatively, you can select the interval from the Quick Selects drop down menu. The metrics are refreshed immediately for the selected interval.
  8. For each metric, you can choose the interval and statistic independently.
    • Interval - The time period for which the metric is calculated.
    • Statistic - The mathematical method by which the metric is calculated.
  9. For each metric, you can choose the following options from the 'Options' drop down menu.
    • View Query in Metrics Explorer

    • Copy Chart URL

    • Copy Query (MQL)

    • Create an Alarm on this Query
    • Table View

For Detailed information on various options for viewing the metrics chart, see Viewing Default Metric Charts.

View Metrics for VM Clusters in a Compartment

Perform the following steps to view the metrics for databases in a compartment using the console.

  1. Open the Oracle Cloud Infrastructure Console by clicking the menu icon next to Oracle Cloud.
  2. From the left navigation list click Observability & Management.
  3. Under Monitoring, click Service Metrics.
  4. On the Service Metrics page, under Compartment select your compartment.
  5. On the Service Metrics page, under Metric Namespace select oci_database_cluster.
  6. If there are multiple VM clusters in the compartment you can show metrics aggregated across the clusters by selecting Aggregate Metric Streams.
  7. If you want to limit the metrics you see, next to Dimensions click Add (click Edit if you have already added dimensions).
  8. In the Dimension Name field select a dimension.
  9. In the Dimension Value field select a value.
  10. Click Done.
  11. In the Edit dimensions dialog click +Additional Dimension to add an additional dimension. Click X to remove a dimension.
  12. To create an alarm on a specific metric, click Options and select Create an Alarm on this Query. See Managing Alarms for information on setting and using alarms.
Note

If you don't see any metrics, check the network settings and AHF version listed in the prerequisites section.

View Metrics for Databases in a Compartment

Perform the following steps to view the metrics for databases in a compartment using the console.

  1. Open the Oracle Cloud Infrastructure Console by clicking the menu icon next to Oracle Cloud.
  2. From the left navigation list click Observability & Management.
  3. Under Monitoring, click Service Metrics.
  4. On the Service Metrics page, under Compartment select your compartment.
  5. On the Service Metrics page, under Metric Namespace select oci_database.
  6. If there are multiple databases in the compartment you can show metrics aggregated across the databases by selecting Aggregate Metric Streams.
  7. If you want to limit the metrics you see, next to Dimensions click Add (click Edit if you have already added dimensions).
  8. In the Dimension Name field select a dimension.
  9. In the Dimension Value field select a value.
  10. Click Done.
  11. In the Edit dimensions dialog click +Additional Dimension to add an additional dimension. Click X to remove a dimension.
  12. To create an alarm on a specific metric, click Options and select Create an Alarm on this Query. See Managing Alarms for information on setting and using alarms.

Manage Oracle Trace File Analyzer

  • To check the run status of Oracle Trace File Analyzer, run the tfactl status command as root or a non-root user:
    # tfactl status 
    .-------------------------------------------------------------------------------------------------.
    | Host           | Status of TFA | PID    | Port | Version    | Build ID             | Inventory Status|
    +----------------+---------------+--------+------+------------+----------------------+------------+
    | node1          | RUNNING       |  41312 | 5000 | 22.1.0.0.0 | 22100020220310214615| COMPLETE    |
    | node2          | RUNNING       | 272300 | 5000 | 22.1.0.0.0 | 22100020220310214615| COMPLETE    |
    '----------------+---------------+--------+------+------------+----------------------+------------'
  • To start the Oracle Trace File Analyzer daemon on the local node, run the tfactl startcommand as root:
    # tfactl start
    Starting TFA..
    Waiting up to 100 seconds for TFA to be started..
    . . . . .
    . . . . .
    . . . . .
    . . . . .
    . . . . .
    . . . . .
    . . . . .
    . . . . .
    Successfully started TFA Process..
    . . . . .
    TFA Started and listening for commands
  • To stop the Oracle Trace File Analyzer daemon on the local node, run the tfactl stop command as root:
    # tfactl stop
    Stopping TFA from the Command Line
    Nothing to do !
    Please wait while TFA stops
    Please wait while TFA stops
    TFA-00002 Oracle Trace File Analyzer (TFA) is not running
    TFA Stopped Successfully
    Successfully stopped TFA..

Manage Database Service Agent

View the /opt/oracle/dcs/log/dcs-agent.log file to identify issues with the agent.

  • To check the status of the Database Service Agent, run the systemctl status command:
    # systemctl status dbcsagent.service
    dbcsagent.service
    Loaded: loaded (/usr/lib/systemd/system/dbcsagent.service; enabled; vendor preset: disabled)
    Active: active (running) since Fri 2022-04-0113:40:19UTC; 6min ago
    Process: 9603ExecStopPost=/bin/bash -c kill `ps -fu opc |grep "java.*dbcs-agent.*jar"|awk '{print $2}'` (code=exited, status=0/SUCCESS)
    Main PID: 10055(sudo)
    CGroup: /system.slice/dbcsagent.service
    ‣ 10055sudo -u opc /bin/bash -c umask 077; /bin/java
  • To start the agent if it is not running, run the systemctl start command as the root user:
    systemctl start dbcsagent.service

Metrics for Oracle Exadata Database Service on Dedicated Infrastructure in the Monitoring Service

This article describes the metrics emitted by the Exadata Cloud Infrastructure Database service in the oci_database_cluster and oci_database namespaces for Oracle Databases.

Dimensions

All the metrics discussed in this topic include the following dimensions.

  • RESOURCEID - The OCID of the VM Cluster.
  • RESOURCENAME - The name of the VM Cluster.

The metrics listed in the following table are automatically available for the VM cluster.

Metric Name Metric Display Name Unit Description and Metric Chart Defaults Collection Frequency Dimensions
ASMDiskgroupUtilization ASM Diskgroup Utilization percentage Percentage of usable space used in a Disk Group. Usable space is the space available for growth. DATA disk group stores our Oracle database files. RECO disk group contains database files for recovery such as archives and flashback logs. 10 minutes

hostName

deploymentType

diskgroupName

CpuUtilization CPU Utilization percentage Percent CPU utilization 1 minute

hostName

deploymentType

FilesystemUtilization Filesystem Utilization percentage Percent utilization of provisioned filesystem 1 minute

hostName

deploymentType

filesystemName

LoadAverage Load Average integer System load average over 5 minutes 1 minute

hostName

deploymentType

MemoryUtilization Memory Utilization percentage Percentage of memory available for starting new applications, without swapping. The available memory can be obtained via the following command: cat /proc/meminfo 1 minute

hostName

deploymentType

NodeStatus Node Status integer Indicates whether the host is reachable. 1 minute

hostName

deploymentType

OcpusAllocated OCPU Allocated integer The number of OCPUs allocated 1 minute deploymentType
SwapUtilization Swap Utilization percentage Percent utilization of total swap space 1 minute

hostName

deploymentType

The metrics listed in the following table are automatically available for the database.

Metric Name Metric Display Name Unit Dsicription and Metric Chart Defaults Collection Frequency Dimensions
CpuUtilization CPU Utilization percentage The CPU utilization expressed as a percentage, aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

StorageUtilization Storage Utilization percentage The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. 1 hour

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

BlockChanges DB Block Changes Changes per second The Average number of blocks changed per second. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

ExecuteCount Execute Count Count The number of user and recursive calls that executed SQL statements during the selected interval. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

ExecuteCount Execute Count Count The number of user and recursive calls that executed SQL statements during the selected interval. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

CurrentLogons Current Logons Count The number of successful logons during the selected interval. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

TransactionCount Transaction Count Count The combined number of user commits and user rollbacks during the selected interval. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

UserCalls User Calls Count The combined number of logons, parses, and execute calls during the selected interval. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

ParseCount Parse Count Count The number of hard and soft parses during the selected interval. 5 minutes

instanceNumber

instanceName

hostName

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

StorageUsed Storage Space Used GB Total amount of storage space used by the database at the collection time. 1 hour

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

StorageAllocated Storage Space Allocated GB Total amount of storage space allocated to the database at the collection time 1 hour

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

StorageUsedByTablespace Storage Space Used By Tablespace GB Total amount of storage space used by tablespace at the collection time. In case of container database, this metric provides root container tablespaces. 1 hour

tablespaceName,

tablespaceType

deploymentType

resourceId_{database|pdb}

resourceName_{database|pdb}

StorageAllocatedByTablespace Allocated Storage Space By Tablespace GB Total amount of storage space allocated to the tablespace at the collection time. In case of container database, this metric provides root container tablespaces. 1 hour

TablespaceName,

tablespaceType,

deploymentType,

resourceId_{database|pdb}

resourceName_{database|pdb}

StorageUtilizationByTablespace Storage Space Utilization By Tablespace percentage This indicates the percentage of storage space utilized by the tablespace at the collection time. In case of container database, this metric provides root container tablespaces.. 1 hour

tablespaceName,

tablespaceType

deploymentType

Metrics for Exadata Cloud Infrastruture in the Database Management Service

This article describes the metrics emitted by the Exadata Cloud Infrastructure Database service in the oracle_oci_database namespace for Oracle Databases.

To use database metrics for these Oracle Databases in Exadata Cloud Infrastructure Database Service, you must enable Database Management for the database you want to monitor. You can enable either Basic Management or Full Management for your database. See Enable Database Management for instructions.

Dimensions

All the metrics discussed in this topic include the following dimensions.

  • RESOURCEID - The OCID of the database.
  • RESOURCENAME - The name of the database.
  • DEPLOYMENTTYPE - The deployment type of the database.

Note: Valid alarm intervals are 5 minutes or greater due to the frequency at which these metrics are emitted. See To create an alarm for details on creating alarms.

The database metrics can be provided for the basic and full Database Management options.

The metrics listed in the following table are automatically available for Oracle Databases when the Basic Database Management option is enabled.

Metric Name Metric Display Name Unit Description and Metric Chart Defaults Collection Frequency Dimensions
BlockChanges DB Block Changes changes per second

The average number of blocks changed per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

CpuUtilization CPU Utilization percent

The CPU utilization expressed as a percentage, aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

CurrentLogons Current Logons count

The number of successful logons during the selected interval.

Statistics: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

ExecuteCount Execute Count count

The number of user and recursive calls that executed SQL statements during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

OcpusAllocated OCPU Allocated integer

The actual number of OCPUs allocated by the service during the selected interval of time.

Statistic: Count

Interval: 1 minute

5 minutes N/A
ParseCount Parse Count (Total) count

The number of hard and soft parses during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

StorageAllocated Allocated Storage Space GB

The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes N/A
StorageAllocatedByTablespace Allocated Storage Space By Tablespace GB

The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

StorageUsed Storage Space Used GB

The maximum amount of space used during the interval.

Statistic: Max

Interval: 30 minutes

30 minutes N/A
StorageUsedByTablespace Storage Space Used By Tablespace GB

The maximum amount of space used by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

StorageUtilization Storage Utilization percent

The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.

Statistic: Mean

Interval: 30 minutes

30 minutes N/A
StorageUtilizationByTablespace Storage Space Utilization By Tablespace percent

The percentage of the space utilized, by tablespace. For container databases, this metric provides data for root container tablespaces.

Statistic: mean

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

TransactionCount Transaction Count count

The combined number of user commits and user rollbacks during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

UserCalls User Calls count

The combined number of logons, parses, and execute calls during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

The metrics listed in the following table are automatically available for Oracle Databases when the Full Database Management option is enabled.

Metric Name Metric Display Name Unit Description and Metric Chart Defaults Collection Frequency Dimensions
AllocatedStorageUtilizationByTablespace Allocated Space Utilization By Tablespace percent

The percentage of space used by tablespace, out of all allocated. For container databases, this metric provides data for root container tablespaces.

Statistic: Mean

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

AvgGCCRBlockReceiveTime Average GC CR Block Receive Time milliseconds

The average global cache CR (consistent-read) block receive time.

Statistic: Mean

Interval: 5 minutes

For RAC / cluster databases only.

5 minutes

instanceNumber

instanceName

hostName

BlockingSessions Blocking Sessions count

Current blocking sessions.

Statistic: Max

Interval: 15 minutes

Not applicable for container databases.

15 minutes N/A
CPUTime CPU Time seconds per second

The average rate of accumulation of CPU time by foreground sessions in the database instance over the time interval. The CPU time component of Average Active Sessions.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

DbmgmtJobExecutionsCount ?? ??

The number of SQL job executions on a single managed database or a database group, and their status. Status dimensions can be the following values: "Succeeded," "Failed," "InProgress."

Statistic: Sum

Interval: 1 minute

??

managedDatabaseId

managedDatabaseGroupId

jobId

status

DBTime DB Time seconds per second

The average rate of accumulation of database time (CPU + Wait) by foreground sessions in the database instance over the time interval. Also known as Average Active Sessions.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

FRASpaceLimit Flash Recovery Area Limit GB

The flash recovery area space limit.

Statistic: Max

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
FRAUtilization Flash Recovery Area Utilization percent

The flash recovery area utilization.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
GCCRBlocksReceived GC CR Blocks Received blocks per second

The global cache CR (consistent-read) blocks received per second.

Statistic: Mean

Interval: 5 minutes

For RAC / cluster databases only.

5 minutes

instanceNumber

instanceName

hostName

GCCurrentBlocksReceived GC Current Blocks Received blocks per second

Represents global cache current blocks received per second. Statistic reports the mean value.

Statistic: Mean

Interval: 5 minutes

For Real Application Cluster (RAC) databases only.

5 minutes

instanceNumber

instanceName

hostName

InterconnectTraffic Average Interconnect Traffic MB per second

The average internode data transfer rate.

Statistic: Mean

Interval: 5 minutes

For RAC / cluster databases only.

5 minutes

instanceNumber

instanceName

hostName

InvalidObjects Invalid Objects count

Invalid database objects count.

Statistic: Max

Interval: 24 hours

Not applicable for container databases.

24 hours N/A
IOPS IOPS operations per second

The average number of input-output operations per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

ioType (Read, Write)

IOThroughput IO Throughput MB per second

The average throughput in MB per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

ioType (Read, Write)

LogicalBlocksRead Logical Reads reads per second

The average number of blocks read from SGA/Memory (buffer cache) per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

MaxTablespaceSize Max Tablespace Size GB

The maximum possible tablespace size. For container databases, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

MemoryUsage Memory Usage MB

Memory pool total size in MB.

Statistic: Mean

Interval: 15 minutes

15 minutes

instanceNumber

instanceName

hostName

memoryType (SGA, PGA)

memoryPool (AllocatedPGA, Buffercachel, FixedSGA, JavaPool, LargePool, LogBuffer, OtherPools, SharedPool, StreamsPool )

MonitoringStatus Monitoring Status not applicable

The monitoring status of the resource. If a metric collection fails, error information is captured in this metric.

Statistic: Mean

Interval: 5 minutes

5 minutes

collectionName

errorSeverity

errorCode

NonReclaimableFRA Non Reclaimable Fast Recovery Area percent

The Non-reclaimable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
ParsesByType Parses By Type parses per second

The number of hard or soft parses per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

parseType (HardParse, SoftParse)

ProblematicScheduledDBMSJobs Problematic Scheduled DBMS Jobs count

The problematic scheduled database jobs count.

Statistic: Max

Interval: 15 minutes

Not applicable for container databases.

15 minutes type (Broken, Failed)
Processes Process Count count

The database processes count.

Statistic: Max

Interval: 1 minute

Not applicable for pluggable databases.

5 minutes

instanceNumber

instanceName

hostName

ProcessLimitUtilization Process Limit Utilization percent

The process limit utilization.

Statistic: Mean

Interval: 1 minute

Not applicable for pluggable databases.

5 minutes

instanceNumber

instanceName

hostName

ReclaimableFRA Reclaimable Fast Recovery Area percent

The reclaimable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
ReclaimableFRASpace Flash Recovery Area Reclaimable Space GB

The flash recovery area reclaimable space.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
RedoSize Redo Generated MB per second

The average amount of redo generated, in MB per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

SessionLimitUtilization Session Limit Utilization percent

The session limit utilization.

Statistic: Mean

Interval: 1 minute

Not applicable for pluggable databases.

5 minutes

instanceNumber

instanceName

hostName

Sessions Sessions count

The number of sessions in the database.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

TransactionsByStatus Transactions By Status transactions per second

The number of committed or rolled back transactions per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

transactionStatus (Committed, RolledBack)

UnusableIndexes Unusable Indexes count

Unusable indexes count in database schema.

Statistic: Max

Interval: 24 hours

Not applicable for container databases.

24 hours schemaName
UsableFRA Usable Fast Recovery Area percent

The useable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
UsedFRASpace Flash Recovery Area Usage GB

The flash recovery area space usage.

Statistic: Max

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
WaitTime Wait Time seconds per second

The average rate of accumulation of non-idle wait time by foreground sessions in the database instance over the time interval. The wait time component of Average Active Sessions.

Statistic: Mean

Interval: 5 minutes

5 minutes

instanceNumber

instanceName

hostName

waitClass