Top Statements by CPU Time Metrics

The metrics in this category provide details about the SQL statements that use the most processor time.

Default Collection Interval - Every 30 minutes

Table 3-41 Top Statements by CPU Time Metrics

Metric Description

Statement Hash

A hash of the SQL statement text.

Statement

The SQL statement executed.

Total CPU Time (s)

The amount of time the statement was executing while Enterprise Manager collected data.

CPU Time per hour (s)

The average amount of time the statement is executing, per hour.