Oracle Application Express facilitates the monitoring of resources used by applications and pages by calling the package DBMS_APPLICATION_INFO
. Whenever the Application Express engine renders or processes a page, the module is set to APEX
and includes the application ID and page number. Once set, you can query the V$SESSION
and V$SQLAREA
views to monitor transactions.