Databases Reference
In-Depth Information
At the top of the
Debug Message Data
window (see the previous screenshot), there
is a graphical representation of the execution times. This makes it easy to narrow
down where most of the time is spent on the page. Clicking on the graph on the top
will navigate to the appropriate line in the report. A similar graph is shown per line
in the report; the wider the bar, the more time this line takes.
The previous screenshot shows the information that can be found in the debug
information: authentication information, validation checks, assignments and session
state information, values assigned in queries, and much more.
Debug information can also be queried through the
APEX_DEBUG_MESSAGES
view. The actual debug information
is stored in two data dictionary tables:
WWV_FLOW_DEBUG_
MESSAGES
and
WWV_FLOW_DEBUG_MESSAGES2
.
In Application Express 4.2
The
APEX_DEBUG_MESSAGE
has been renamed to
APEX_DEBUG
. In the top-level description, it should be
speciied that the module can still be accessed by its
previous name,
APEX_DEBUG_MESSAGE
, for compatibility
reasons, but the new name is preferred.
The following table lists the columns in the
APEX_DEBUG_MESSAGES
view:
Column name
Data type
Remark
ID
NUMBER
PAGE_VIEW_ID
NUMBER
Page view identifier, which is a unique
sequence generated for each page view
recorded with debugging
MESSAGE_TIMESTAMP TIMESTAMP(6)
with time zone
Timestamp: In GMT that message was
saved
ELAPSED_TIME
NUMBER
Elapsed time in seconds from the
beginning of page submission or page
view
EXECUTION_TIME
NUMBER
Time elapsed between the current and
the next debug message
MESSAGE
VARCHAR2(4000)
Message
APPLICATION_ID
NUMBER
Application identifier
PAGE_ID
NUMBER
Page identifier within the application
SESSION_ID
NUMBER
APEX session identifier
