Improved table functions provide access to information without having to perform joins

The addition of the APPLICATION_NAME monitor element to MON_GET_ACTIVITY, MON_GET_ACTIVITY_DETAILS, MON_GET_UNIT_OF_WORK and MON_GET_UNIT_OF_WORK_DETAILS allows you to determine the application name for a connection or statement without the need to join your monitor query with MON_GET_CONNECTION

Similarly the addition of WORKLOAD_ID to MON_GET_ACTIVITY and MON_GET_ACTIVITY_DETAILS allows you to view the WORKLOAD for the connection running an activity without having to join your monitor query with other interfaces.

Both of these changes promote simpler use of monitoring by removing the need for joins in some monitor queries.