Oracle Enterprise Manager for MySQL Database
Lists the DML Statement Activity metrics and provides a brief description of each.
Table 8.4 DML Statement Activity Metrics
| Name | Description |
|---|---|
| Target Name | Name of the OEM Target |
| Call Procedure (Delta) | The total number of CALL statements executed. |
| Change DB (Delta) | The total number of USE statements executed. |
| Dealloc SQL (Delta) | The total number of DEALLOCATE PREPARE statements executed. |
| Delete (Delta) | The total number of DELETE statements executed. |
| Delete Multi (Delta) | The total number of multi-table DELETE statements executed. |
| Do Number (Delta) | The total number of DO statements executed. |
| Empty Query (Delta) | The total number of empty queries executed. |
| Execute SQL (Delta) | The total number of EXECUTE statements executed. |
| Ha Close (Delta) | The total number of HANDLER CLOSE statements executed. |
| Ha Open (Delta) | The total number of HANDLER OPEN statements executed. |
| Ha Read (Delta) | The total number of HANDLER READ statements executed. |
| Help (Delta) | The total number of HELP statements executed. |
| Insert (Delta) | The total number of INSERT statements executed. |
| Insert Select (Delta) | The total number of INSERT ... SELECT statements executed. |
| Load (Delta) | The total number of LOAD DATA INFILE statements executed. |
| Lock Tables (Delta) | The total number of LOCK TABLE statements executed. |
| Prepare SQL (Delta) | The total number of PREPARE statements executed. |
| Replace (Delta) | The total number of REPLACE statements executed. |
| Replace Select (Delta) | The total number of REPLACE ... SELECT statements executed. |
| Reset (Delta) | The total number of RESET statements executed. |
| Resignal (Delta) | The total number of RESIGNAL statements executed. |
| Select (Delta) | The total number of SELECT statements executed. |
| Set Option (Delta) | The total number of SET statements executed. |
| Signal (Delta) | The total number of SIGNAL statements executed. |
| Stmt Close (Delta) | The total number of DEALLOCATE PREPARE statements, or mysql_stmt_close() calls, executed. |
| Stmt Execute (Delta) | The total number of EXECUTE statements, or mysql_stmt_execute() calls, executed. |
| Stmt Fetch (Delta) | The total number of mysql_stmt_fetch() calls executed. |
| Stmt Prepare (Delta) | The total number of PREPARE statements, mysql_stmt_prepare() calls, executed. |
| Stmt Reprepare (Delta) | The total number of re-prepare operations executed for prepared statements. |
| Stmt Reset (Delta) | The total number of mysql_stmt_reset() calls executed. |
| Stmt Send Long Data (Delta) | The total number of mysql_stmt_send_long_data calls executed. |
| Unlock Tables (Delta) | The total number of UNLOCK TABLES statements executed. |
| Update (Delta) | The total number of UPDATE statements executed. |
| Update Multi (Delta) | The total number of multi-table UPDATE statements executed. |
| All INSERT Statements (Delta) | The sum of INSERT and INSERT ... SELECT statements within the last interval. |
| All UPDATE Statements (Delta) | The sum of single table and multi-table UPDATE statements within the last interval. |
| All REPLACE Statements (Delta) | The sum of REPLACE and REPLACE ... SELECT statements within the last interval. |
| All DELETE statements (Delta) | The sum of single table and multi-table DELETE statements within the last interval. |