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
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]

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.