mon_rtn_data - Monitoring routine capture configuration parameter
The mon_rtn_data configuration parameter controls the capture of routine invocations. It is a parent parameter to the mon_rtn_execlist configuration parameter.
- Configuration type
- Database
- Applies to
- Database server with local and remote clients
- Database server with local clients
- Partitioned database server with local and remote clients
- Parameter type
- Configurable online
- Propagation class
- Next routine invocation
- Default [range]
- NONE [NONE,BASE]
If the value of mon_rtn_data is set to BASE, then routine monitoring is enabled. Information about executed routines can be accessed using the MON_GET_ROUTINE and MON_GET_ROUTINE_DETAILS interfaces. Routine information is stored in the database heap memory pool. Routine statement monitoring can also be enabled using the mon_rtn_execlist configuration parameter when mon_rtn_data is set to BASE.
If the value of mon_rtn_data is set to NONE, then routine monitoring is disabled. No information is reported in the MON_GET_ROUTINE, MON_GET_ROUTINE_DETAILS, and MON_GET_ROUTINE_EXEC_LIST interfaces. When the mon_rtn_data value is changed to NONE, all preexisting routine monitoring information is deleted.