Oracle Database

Capacity

The following table lists the metrics and their descriptions.

Metric	Description
CPU Capacity	CPU capacity
Memory Capacity	Memory capacity (in GB)

Character Set

The following table lists the metric and its descriptions.

Metric	Description
Character Set	Character set

CPU

The following table lists the metrics and their descriptions.

Metric	Description
CPU Usage	CPU usage (in seconds)
CPU Utilization	Percentage of CPU utilization
CPU Load	Total CPU load
Interval	Interval for metric collection

Creation Date

The following table lists the metric and its descriptions.

Metric	Description
Creation Data	Date of Creation

Database Activity

The following table lists the metrics and their descriptions.

Metric	Description
DB Time	Amount of elapsed time (in seconds) spent on performing database user-level calls
Background CPU	Amount of CPU time (in seconds) consumed by database background processes
SQL Execution	Amount of elapsed time (in seconds) that SQL statements are executing
Instance Name	RDB instance
Host Name	Host name of the instance
CPU Time	CPU time (in seconds) of foreground sessions
Wait Time	Wait time (in seconds) of foreground sessions
I/O Time	I/O time (in seconds) of foreground sessions

Efficiency

The following table lists the metrics and their descriptions.

Metric	Description
Sorts in Memory	Percentage of sorts in memory
Soft Parses	Percentage of soft parses

I/O Bandwidth Usage

The following table lists the metric and its description.

Metric	Description
I/O Bandwidth Usage	Total I/O bandwidth usage

I/O Per Second

The following table lists the metric and its description.

Metric	Description
I/O Per Second	I/O per second

I/O Per Second Instance Level

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	RDB Instance
Host Name	Host name of the instance
I/O Per Second	I/O per second for this instance
I/O Bandwidth Usage	I/O bandwidth usage during the last collection interval for this instance

Instance CPU

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	RDB Instance
Host Name	Host name of the instance
CPU Usage	Usage of all CPUs for this instance, during the interval
CPU Utilization	Percentage of CPU utilized in this interval
Interval	Interval of metric collection

Instance Efficiency

The following table lists the metrics and their descriptions.

Metric	Description
Instance ID	Instance ID
PGA Cache Hit Percent	Percentage of PGA cache hits

Instance Load

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	RDB Instance
Host Name	Host name of the instance
Logons	The number of logons during the last collection interval
Logons Rate	Number of logons per second during the last collection interval
Transactions	Number of transactions during the last collection interval
Transactions Rate	Number of transactions per second during the last collection interval
Executions	Number of executions during the last collection interval
Executions Rate	Number of executions per second during the last collection interval
Network I/O	Number of bytes sent and received over the network during the last collection interval
Network I/O Rate	Network I/O in bytes per second during the last collection interval
User Calls	User calls
Physical Read I/O Requests	Physical read I/O requests
Physical Read Bytes	Physical read bytes
Physical Write I/O Requests	Physical write I/O requests
Physical Write Bytes	Physical write bytes
Redo Bytes	Redo bytes
Redo Writes	Redo writes

Instance Memory Usage

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	RDB instance
Host Name	Host name of the instance
Instance Memory Usage	Memory used in GB
Memory Utilization	Percentage of memory that’s utilized in this instance
Interval	Interval of metric collection

Instance Response

The following table lists the metrics and their descriptions.

Metrics	Description
Instance ID	ID of the instance
Status	Status of the instance

Interconnect Usage Statistics

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	Database instance name
Host Name	Host name for instance
Bytes Sent	Number of bytes sent over interconnect
Bytes Received	Number of bytes received over interconnect

Latency

The following table lists the metrics and their descriptions.

Metrics	Description
SQL Service Response Time	SQL server response time
Average Synchronous Single-Block Read Latency	Average synchronous single-block read latency
Average Wait Time for Log File Synchronization	Average wait time for log file synchronization
Average Wait Time for Sequential Read of Datafile	Average wait time for a sequential read of the data files

Limit Utilization

The following table lists the metrics and their descriptions.

Metric	Description
Process Limit Utilization	Percentage of the process limit that has been utilized
Session Limit Utilization	Percentage of the session limit that has been utilized

Load

The following table lists the metrics and their descriptions.

Metric	Description
Average Active Sessions	Average active sessions
Logons	Total number of logons
Logons Rate	Number of logons per second
Transactions	Total number of transactions
Transactions Rate	Number of transactions per second
Executions	Total number of executions
Executions Rate	Number of executions per second
Network I/O	Total network I/O (in bytes)
Network I/O Rate	I/O per second

Memory

The following table lists the metrics and their description.

Metric	Description
Memory Usage	Memory usage (in GB)
Memory Utilization	Percentage of memory utilization
Memory Load	Total memory load
Interval	Interval for metric collection

Memory Component Sizes

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	Database instance name
Host Name	Host name for instance
Memory Type	Memory type
Memory Pool Name	Memory pool name
Allocated Size	Allocated memory size in bytes

Operating System Statistics

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	RDB Instance
Host Name	Host name of the instance
Total CPUs	Total number of CPUs allocated or available in this instance
Total Memory	Total amount of usable physical RAM allocated or available in this instance

Parameter

The following table lists the metrics and their descriptions.

Metric	Description
Instance ID	Instance ID
Container ID	Container ID
Parameter Name	Name of the parameter
Parameter Value	Value of the parameter

Product

The following table lists the metrics and their descriptions.

Metric	Description
Vendor	Product vendor
Name	Product name
Version	Product version

Response

The following table lists the metric and its descriptions.

Metric	Description
Status	Response status

SQL Statistics

The following table lists the metrics and their descriptions.

Metric	Description
Disk Reads	Total number of disk reads
Buffer Gets	Total number of buffer gets
CPU Time	Total time (in milliseconds) spent on CPU
User I/O Wait	Total time (in milliseconds) spent waiting for events in the User I/O class
Cluster Wait	Total time (in milliseconds) spent waiting for events in the Cluster class
Application Wait	Total time (in milliseconds) spent waiting for events in the Application class
Concurrency Wait	Total time (in milliseconds) spend waiting for events in the Concurrency class
Direct Writes	Number of direct writes
Physical Read Requests	Number of physical read I/O requests issued by the SQL
Physical Read Bytes	Number of bytes read from disks by the SQL
Physical Write Requests	Number of physical write I/O requests issued by the SQL
Physical Write Bytes	Number of bytes written to disks by the SQL
SQL ID	SQL ID
Plan Hash Value	Numerical representation of the SQL plan for the cursor
Executions	Number of times the SQL statement was executed
Elapsed Time	Total time (in milliseconds) used by this SQL for parsing, executing, and fetching

Storage Space Usage

The following table lists the metrics and their descriptions.

Metric	Description
Storage Space Allocated	Total allocated storage space (in GB)
Storage Space Utilization	Percentage of allocated storage space that has been utilized
Space Used	Total space used (in GB)

Storage Usage by Tablespace

The following table lists the metrics and their descriptions.

Metric	Description
Storage Tablespace Name	Tablespace name
Total Space Allocated	Total size of a tablespace’s data files in GB
Space Utilization Percentage	Percent of storage space utilized
Space Used	Tablespace used in GB

System Wait Classes

The following table lists the metrics and their descriptions.

Metric	Description
Instance Name	Database instance name
Host Name	Host name of instance
Wait Class	Wait class
Time Waited	Total time waited in seconds by both foreground and background sessions
Time Waited Foreground	Total time waited in seconds by foreground sessions only

Top SQL Executions

The following table lists the metrics and their descriptions.

Metric	Description
SQL ID	ID of the SQL query
CPU Time	CPU time used to process the query
Elapsed Time	Time elapsed before the query results were returned
Top SQL Text	Text of the top SQL queries
Execution Count	Execution count (in seconds)

Top Wait Events

The following table lists the metrics and their descriptions.

Metric	Description
Wait Event Name	Name of the wait event
Wait Class Name	Name of the wait class
Total Waits	Total number of wait events
Total Wait Time	Total wait time
Average Wait Time	Average wait time
Total Foreground Waits	Total number of foreground waits
Total Foreground Wait Time	Total time of foreground waits
Average Foreground Wait Time	Average time of foreground waits

Total Memory Capacity

The following table lists the metric and its descriptions.

Metric	Description
Host Memory	Total host memory (in GB)