Monitoring routines using table functions
You can use table functions to retrieve information about routines.
Table functions can be used to monitor routines and provide the
following information:
- Aggregated metrics that report the total cost of the routine. Metrics are aggregated across all invocations of the routine and include metrics for all child statements and requests that are executed by the routine.
- Lists of statements that are executed by routines that assist you in drilling down and problem determination
- Lists of routines that might be invoked by a statement that aid you in performing additional drill downs on routine-related details.
Use the following monitor functions to access information about
routines:
- MON_GET_ROUTINE
- MON_GET_ROUTINE_DETAILS
- MON_GET_ROUTINE_EXEC_LIST
- MON_GET_SECTION_ROUTINE