This discussion is archived
2 Replies Latest reply: May 16, 2013 8:50 AM by Tony Andrews RSS

APEX 4.1 V$SESSION settings

Tony Andrews Explorer
Currently Being Moderated
According to the Application Express Application Builder User's Guide (4.1) (http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/debug_monitor_resource.htm#HTMDB10005) "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."

However we are using APEX 4.1.1.00.23 and find that V$SESSION.MODULE contains only the application ID, not the page ID e.g. "MYSCHEMA/APEX:APP 123". The ACTION column sometimes has the page ID e.g. "PAGE 100", but more often hold other information instead such as "Process - point: BEFORE_BOX_BO".

We would really like to be able to glean the application ID and page ID for active sessions somehow - can anyone suggest how this can be reliably done in APEX 4.1?

Edited by: Tony Andrews on May 16, 2013 12:32 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points