Table 3.2 Statements Performance Page Regions
| Graph | Description |
|---|---|
| DML Statements | Graphs the number and type of DML statements. The following statement types are graphed: SELECT, INSERT, UPDATE, REPLACE, DELETE and Call Procedures. |
| Transaction Statements | Graphs the number and type of Transaction statements. The following transaction statements are graphed: BEGIN, COMMIT, ROLLBACK, SAVEPOINT, ROLLBACK TO SAVEPOINT and RELEASE SAVEPOINT. |
| Row Activity | Graphs the type of row activity and the number of rows acted upon. |
| Index Usage Ratio | Graphs the change in rows read by indexes versus rows read by table scans. |
| Temporary Tables | Graphs the number of temporary tables created in the database and on disk. |
| Sort Activity | Graphs the number of sort merge passes, the number of sorts done using ranges, and the number of sorts performed by scanning tables. |
| Statement Configuration | Lists the statement-specific system variables and their values. |
| Optimizer Configuration | Lists the optimizer-specific system variables and their values. |