2.14 Top Statements by Execution Count Metrics

The metrics in this category provide details about the SQL statements that are executed most frequently.

Default Collection Interval - Every 30 minutes

Table 2-42 Top Statements by Execution Count Metrics

Metric Description

Statement Hash

A hash of the SQL statement text.

Statement

The SQL statement executed.

Total Execution Count

The number of times the statement executed while Enterprise Manager collected data.

Total Execution Count per Hour

The average number of times the statement executes, per hour.