แก้ไข

แชร์ผ่าน


Supported metrics for Oracle.Database/autonomousDatabases

The following table lists the metrics available for the Oracle.Database/autonomousDatabases resource type.

Table headings

Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.

For information on exporting metrics, see Create diagnostic settings in Azure Monitor.

For information on metric retention, see Azure Monitor Metrics overview.

Category Metric Name in REST API Unit Aggregation Dimensions Time Grains DS Export
Saturation Active APEX Applications

The number of APEX applications that had activity over the time interval.
oci_autonomous_database/APEXApps Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation APEX Page Events

The number of APEX page events over the time interval.
oci_autonomous_database/APEXPageEvents Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Latency APEX Page Load Time

Average APEX page execution time over the time interval.
oci_autonomous_database/APEXPageLoadTime CountPerSecond Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation APEX Workspace Count

Total number of user-created APEX workspaces at given time.
oci_autonomous_database/APEXWorkspaceCount Count Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Latency Connection Latency

The time taken to connect to an Oracle Autonomous Database Serverless instance in each region from a Compute service virtual machine in the same region. (Statistic: Max, Interval: 5 minutes)
oci_autonomous_database/ConnectionLatency Milliseconds Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation CPU Time

Average rate of accumulation of CPU time by foreground sessions in the database over the time interval. (Statistic: Mean, Interval: 1 minute)
oci_autonomous_database/CPUTime CountPerSecond Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation CPU Utilization

The CPU usage 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. (Statistic: Mean, Interval: 1 minute)
oci_autonomous_database/CpuUtilization Percent Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Traffic Current Logons

The number of successful logons during the selected interval. (Statistic: Count, Interval: 1 minute)
oci_autonomous_database/CurrentLogons Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Availability Database Availability

The database is available for connections in the given minute, with possible values: 1 = DB Available, 0 = DB Unavailable. (Statistic: Mean, Interval: 1 minute)
oci_autonomous_database/DatabaseAvailability Count Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation DB Block Changes

The number of changes that were part of an update or delete operation that were made to all blocks in the SGA. Such changes generate redo log entries and thus become permanent changes to the database if the transaction is committed. This approximates total database work. This statistic indicates the rate at which buffers are being dirtied, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/DBBlockChanges Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation DB Time

The amount of time database user sessions spend executing database code (CPU Time + WaitTime). DB Time is used to infer database call latency, because DB Time increases in direct proportion to both database call latency (response time) and call volume. It is calculated as the average rate of accumulation of database time by foreground sessions in the database over the time interval. (Statistic: Mean, Interval: 1 minute)
oci_autonomous_database/DBTime CountPerSecond Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Traffic Execute Count

The number of user and recursive calls that executed SQL statements during the selected interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/ExecuteCount Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Error Failed Connections

The number of failed database connections. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/FailedConnections Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Error Failed Logons

The number of log ons that failed because of an invalid user name and/or password, during the selected interval. (Statistic: Mean, Interval: 1 minute)
oci_autonomous_database/FailedLogons Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Parse Count (Hard)

The number of parse calls (real parses) during the selected time interval. A hard parse is an expensive operation in terms of memory use, because it requires Oracle to allocate a workheap and other memory structures and then build a parse tree. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/HardParseCount Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Session Logical Reads

The sum of "db block gets" plus "consistent gets", during the selected time interval. This includes logical reads of database blocks from either the buffer cache or process private memory.
oci_autonomous_database/LogicalReads Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Parse Count (Total)

The number of hard and soft parses during the selected interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/ParseCount Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Error Parse Count (Failures)

The number of parse failures during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/ParseFailureCount Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Physical Reads

The number of data blocks read from disk, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/PhysicalReads Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Physical Read Total Bytes

The size in bytes of disk reads by all database instance activity including application reads, backup and recovery, and other utilities, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/PhysicalReadTotalBytes Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Physical Writes

The number of data blocks written to disk, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/PhysicalWrites Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Physical Write Total Bytes

The size in bytes of all disk writes for the database instance including application activity, backup and recovery, and other utilities, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/PhysicalWriteTotalBytes Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Latency Query Latency

The time taken to display the results of a simple query on the user's screen. (Statistic: Max, Interval: 5 minutes)
oci_autonomous_database/QueryLatency Milliseconds Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Traffic Queued Statements

The number of queued SQL statements, aggregated across all consumer groups, during the selected interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/QueuedStatements Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Redo Generated

Amount of redo generated in bytes, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/RedoGenerated Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Traffic Running Statements

The number of running SQL statements, aggregated across all consumer groups, during the selected interval. (Statistic: Mean, Interval: 1 minute)
oci_autonomous_database/RunningStatements Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Traffic Sessions

The number of sessions in the database. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/Sessions Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Bytes Received via SQL*Net from Client

The number of bytes received from the client over Oracle Net Services, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/SQLNetBytesFromClient Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Bytes Received via SQL*Net from DBLink

The number of bytes received from a database link over Oracle Net Services, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/SQLNetBytesFromDBLink Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Bytes Sent via SQL*Net to Client

The number of bytes sent to the client from the foreground processes, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/SQLNetBytesToClient Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Bytes Sent via SQL*Net to DBLink

The number of bytes sent over a database link, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/SQLNetBytesToDBLink Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Saturation Storage Space Allocated

Amount of space allocated to the database for all tablespaces, during the interval. (Statistic: Max, Interval: 1 hour)
oci_autonomous_database/StorageAllocated Bytes Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1H, PT6H, PT12H, P1D Yes
Saturation Maximum Storage Space

Maximum amount of storage reserved for the database during the interval. (Statistic: Max, Interval: 1 hour)
oci_autonomous_database/StorageMax Bytes Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Space Used

Maximum amount of space used during the interval. (Statistic: Max, Interval: 1 hour)
oci_autonomous_database/StorageUsed Bytes Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Utilization

The percentage of the reserved maximum storage currently allocated for all database tablespaces. Represents the total reserved space for all tablespaces. (Statistic: Mean, Interval: 1 hour)
oci_autonomous_database/StorageUtilization Percent Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1H, PT6H, PT12H, P1D Yes
Traffic Transaction Count

The combined number of user commits and user rollbacks during the selected interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/TransactionCount Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Traffic User Calls

The combined number of logons, parses, and execute calls during the selected interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/UserCalls Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Traffic User Commits

The number of user commits during the selected time interval. When a user commits a transaction, the generated redo that reflects the changes made to database blocks must be written to disk. Commits often represent the closest thing to a user transaction rate. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/UserCommits Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Traffic User Rollbacks

Number of times users manually issue the ROLLBACK statement or an error occurs during a user's transactions, during the selected time interval. (Statistic: Sum, Interval: 1 minute)
oci_autonomous_database/UserRollbacks Count Minimum, Maximum, Average, Total (Sum) autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes
Latency Wait Time

Average rate of accumulation of non-idle wait time by foreground sessions in the database over the time interval. (Statistic: Mean, Interval: 1 minute)
oci_autonomous_database/WaitTime CountPerSecond Minimum, Maximum, Average autonomousDbType, deploymentType, displayName, region, Oracle.resourceId, Oracle.resourceName PT1M Yes