The metrics in this category provide details about the SQL statements that use the most processor time.
Default Collection Interval - Every 30 minutes
Table 2-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. |