New monitoring metrics for determining failure rate of SQL statements
It is now possible to monitor the failure rate of an SQL statement using the MON_GET_PKG_CACHE_STMT table function.
The following columns have been added to MON_GET_PKG_CACHE_STMT:
- LAST_EXEC_ERROR: The Error SQLCODE for the last error of this statement
- LAST_EXEC_ERROR_SQLERRMC: The SQLCODE tokens from SQLERRMC for the last error of this statement
- LAST_EXEC_ERROR_TIMESTAMP: Time when the last error for this statement occurred
- LAST_EXEC_WARNING: The Warning SQLCODE for the last warning of this statement
- LAST_EXEC_WARNING_SQLERRMC: The SQLCODE tokens from SQLERRMC for the last warning of this statement
- LAST_EXEC_WARNING_TIMESTAMP: Time when the last warning for this statement occurred
- NUM_EXEC_WITH_ERROR: The number of executions of this statement that resulted in an error
- NUM_EXEC_WITH_WARNING: The number of executions of this statement that resulted in an warning
The MON_GET_PKG_CACHE_STMT_DETAILS table function has also been updated to include this data in the XML document output. Further, the PACKAGE CACHE event monitor has been updated to include this new data, allowing the data to be captured by an active event monitor as statements are evicted from the SQL cache.