Open SQL Statistics 

Use

The SQL Statistics Monitor displays accumulated statistics about JDBC methods executed on each DataSource. The statistics include the number of executions, the elapsed time for execution, and the number of affected rows, if possible. Additionally, some average values for the elapsed time and the affected rows are displayed.

Prerequisites

You are in Problem Management → Database → Open SQL Monitors → Open SQL Statistics.

Activities

To view method execution details for a particular DataSource, select the DataSource. The SQL Statistics Details area opens. To view database access statistics about queries, choose the Queries tab. For each SQL statement, statistical details about Prepare, executeQuery and next calls are displayed. To view details about the executed DML statements regarding Prepare, executeUpdate and executeBatch calls, choose the DMLs tab.