MON_GET_CONNECTION()
table function. This table function retrieves information for all connections currently present in the database. This information can be used to check the health of all applications.
Some important monitor elements that can tell the application behavior can be TOTAL_CPU_TIME per request, TOTAL_WAIT_TIME %, TOTAL_COMMITS, ROWS READ, ROWS MODIFIED
etc.
In general, you may not be interested in all the information returned by this table function. So you can write your SQL query in such a manner that it returns only selective information. One such possible query is as follows:
SELECT APPLICATION_HANDLE, APPLICATION_NAME, TOTAL_CPU_TIME, TOTAL_ACT_TIME, ACT_COMPLETED_TOTAL, TOTAL_WAIT_TIME, CLIENT_IDLE_WAIT_TIME FROM TABLE(MON_GET_CONNECTION(NULL, -1)) as t;