Monitor views

Monitor views are an ideal place to start when interested in basic monitoring.

These views provide a condensed representation of monitoring information, displaying the highlights, as well as providing some of the standard calculations of most interest, such as buffer pool hit ratio.

Views are very similar to table functions; they return data in table format, but unlike table functions, they do not require any input parameters.

The monitor views return metrics on various database activities, for example:
  • MON_BP_UTILIZATION returns key monitoring metrics, including hit ratios and average read and write times, for all buffer pools and all database partitions in the currently connected database.
  • MON_CURRENT_SQL returns metrics for all activities that were submitted on all members of the database and have not yet been completed, including a point-in-time view of currently executing SQL statements.
  • MON_DB_SUMMARY returns metrics aggregated over all service classes.
  • MON_LOCKWAITS returns information about agents working on behalf of applications that are waiting to obtain locks in the currently connected database.
  • MON_SERVICE_SUBCLASS_SUMMARY returns metrics for all service subclasses, showing work executed per service class.
  • MON_CURRENT_UOW returns metrics for all units of work.
  • MON_WORKLOAD_SUMMARY returns metrics for all workloads, showing incoming work per workload.