Autonomous Transaction Processing

Table 1-47 Supported Configuration Metrics for Relational Database

Metric Group	Name	Unit	Description
Creation Date	Creation Date	NA	Date when the database was created

Table 1-48 Supported Configuration Metrics for Hosted Target

Metric Group	Name	Unit	Description
Resource Allocation	Total CPUs	NA	Total number of CPUs allocated or available to the entity

Table 1-49 Supported Configuration Metrics for Target

Metric Group	Name	Unit	Description
Product	Vendor	NA	Vendor of the product
Product	Product	NA	Name of the product
Product	Version	NA	Version of the product

Table 1-50 Supported Status and Performance Metrics for Oracle Database Server Interface

Metric Group	Category	Name	Unit	Description
Latency	Response	SQL Service Response Time	centisec/request	Average Response Time across all SQL statements in centiseconds per call
Latency	Response	Avg Synchronous Single-Block Read Latency	ms	Average latency for single block synchronous reads in milliseconds
Latency	Response	Avg Wait Time for Sequential Read of Datafile	ms	Average wait time for 'db file sequential read' event in milliseconds
Database Activity	Load	DB Time	sec	Amount of elapsed time (in seconds) spent on performing database user-level calls
Database Activity	Load	Background CPU	sec	Amount of CPU time (in seconds) consumed by database background processes
Database Activity	Load	SQL Execution	sec	Amount of elapsed time (in seconds) SQL statements are executing
Instance Load	Load	Physical Read I/O Requests	NA	Physical Read I/O Requests
Instance Load	Load	Physical Read Bytes	bytes	Physical Read Bytes
Instance Load	Load	Physical Write I/O Requests	NA	Physical Write I/O Requests
Instance Load	Load	Physical Write Bytes	bytes	Physical Write Bytes
Instance Load	Load	Redo Bytes	bytes	Redo Bytes
Instance Load	Load	Redo Writes	NA	Redo Writes
SQL Statistics	Load	Disk Reads	NA	Total number of disk reads
SQL Statistics	Load	Buffer Gets	NA	Total number of buffer gets
SQL Statistics	Response	CPU Time	ms	Total time (in milliseconds) spent on CPU
SQL Statistics	Response	User I/O Wait	ms	Total time (in milliseconds) spent waiting for events in the User I/O class
SQL Statistics	Response	Cluster Wait	ms	Total time (in milliseconds) spent waiting for events in the Cluster class
SQL Statistics	Response	Application Wait	ms	Total time (in milliseconds) spent waiting for events in the Application class
SQL Statistics	Response	Concurrency Wait	ms	Total time (in milliseconds) spent waiting for events in the Concurrency class
SQL Statistics	Load	Direct Writes	NA	Number of direct writes
SQL Statistics	Load	Physical Read Requests	NA	Number of physical read I/O requests issued by the SQL
SQL Statistics	Load	Physical Read Bytes	bytes	Number of bytes read from disks by the SQL
SQL Statistics	Load	Physical Write Requests	NA	Number of physical write I/O requests issued by the SQL
SQL Statistics	Load	Physical Write Bytes	bytes	Number of bytes written to disks by the SQL
SQL Statistics from ASH	.	SQL ID	NA	SQL ID
SQL Statistics from ASH	.	Plan Hash Value	NA	Numerical representation of the SQL plan for the cursor
SQL Statistics from ASH	.	Bucket Id	NA	SQL fall under the bucket (Possible Values : lessthan 3 secs, 4-10sec, 11-60sec, 1-5min, 5min or more)
SQL Statistics from ASH	Load	Executions	NA	Number of times the SQL statement was executed in last 30 minutes in the bucket pointed by Bucket ID
SQL Statistics from ASH	Response	Total Time	sec	Total time (in seconds) spent on CPU and all other waits in last 30 minutes in the bucket pointed by Bucket ID
SQL Statistics from ASH	Response	CPU Time	sec	Total time (in seconds) spent waiting for CPU in last 30 minutes in the bucket pointed by Bucket ID
SQL Statistics from ASH	Response	User I/O Wait	sec	Total time (in seconds) spent waiting for events in the User I/O class in last 30 minutes in the bucket pointed by Bucket ID
SQL Statistics from ASH	Response	Other Wait Time	sec	Total time (in seconds) spent on all other waits except I/O in last 30 minutes in the bucket pointed by Bucket ID
System Wait Classes	.	Instance ID	NA	Database Instance ID
System Wait Classes	.	Host Name	NA	Host Name for Instance
System Wait Classes	.	Wait Class	NA	Wait Class
System Wait Classes	Response	Time Waited	sec	Total time waited in seconds by both foreground and background sessions
System Wait Classes	Response	Time Waited Foreground	sec	Total time waited in seconds by foreground sessions only
System Wait Classes	.	Interval	sec	Interval of metric collection

Table 1-51 Supported Status and Performance Metrics for Relational Database

Metric Group	Category	Name	Unit	Description
Storage Space Usage	Utilization	Storage Space Allocated	GB	Storage space allocated in GB
Storage Space Usage	Utilization	Storage Space Utilization	%	Percent of storage space utilized
Storage Space Usage	Load	Space Used	GB	Storage space used in GB
Load	Load	Logons Rate	logons/sec	Number of logons per second during the last collection interval
Load	Load	Transactions Rate	txns/sec	Number of transactions per second during the last collection interval
Load	Load	Execution Rate	executions/sec	Number of executions per second during the last collection interval
Load	Load	Network I/O Rate	bytes/sec	Network I/O in bytes/second during the last collection interval
I/O Performance	Load	I/O Per Second	IOPS	I/O per second.
I/O Performance	Load	I/O Bandwidth Usage	MB/sec	I/O bandwidth usage during the last collection interval
Instance CPU	Utilization	Instance ID	NA	RDB instance
Instance CPU	Utilization	CPU Usage	sec	All CPUs usage during the interval for this instance
Instance CPU	Utilization	CPU Utilization	%	Percentage of CPU that was utilized in this instance
Instance CPU	.	Interval	sec	Interval of metric collection
I/O Per Second Instance Level	Load	Instance ID	NA	RDB instance
I/O Per Second Instance Level	Load	I/O Per Second	IOPS	I/O per second for this instance
I/O Per Second Instance Level	Load	I/O Bandwidth Usage	MB/sec	I/O bandwidth usage during the last collection interval for this instance
I/O Per Second Instance Level	.	Interval	sec	Interval of metric collection
Database Activity	.	Instance ID	NA	RDB instance
Database Activity	.	Host Name	NA	Host name of the instance
Database Activity	Load	CPU Time	sec	CPU time (in seconds) of foreground sessions
Database Activity	Load	Wait Time	sec	Wait time (in seconds) of foreground sessions
Database Activity	Load	I/O Time	sec	I/O time (in seconds) of foreground sessions
Database Activity	.	Interval	sec	Interval of metric collection
Instance Load	.	Instance ID	NA	RDB instance
Instance Load	Load	Logons Rate	logons/sec	Number of logons per second during the last collection interval
Instance Load	Load	Transactions Rate	txns/sec	Number of transactions per second during the last collection interval
Instance Load	Load	Executions Rate	executions/sec	Number of executions per second during the last collection interval
Instance Load	Load	Network I/O Rate	bytes/sec	Network I/O in bytes/second during the last collection interval
Instance Load	.	Interval	sec	Interval of metric collection
SQL Statistics	.	SQL ID	NA	SQL ID
SQL Statistics	.	Plan Hash Value	NA	Numerical representation of the SQL plan for the cursor
SQL Statistics	Load	Executions	NA	Number of times the SQL statement was executed
SQL Statistics	Response	Elapsed Time	ms	Total time (in milliseconds) used by this SQL for parsing, executing and fetching
SQL Statistics	.	Interval	sec	Interval of metric collection

Table 1-52 Supported Status and Performance Metrics for Hosted Target

Metric Group	Category	Name	Unit	Description
CPU	Utilization	CPU Usage	sec	All CPUs usage during the interval
CPU	Utilization	CPU Utilization	%	Percentage of CPU that was utilized
CPU	.	Interval	sec	Interval of metric collection

Table 1-53 Supported Status and Performance Metrics for Target

Metric Group	Category	Name	Unit	Description
Response	Availability	Status	NA	Status of the target