Databases Reference
In-Depth Information
Figure 6-26.
Debug information including session state information for 2 separate pages
The Data Behind Debugging
As mentioned before, APEX Debug data is now kept in a set of data dictionary tables so that it can be
examined and compared to other runs of the same page. In this section we'll look at the underlying
tables and view, the lifetime of the data in them, and how the data differs between when captured
interactively as opposed to programmatically.
Tables and View
Debug data is stored as metadata in the core APEX schema and is split across two tables:
WWV_FLOW_DEBUG_MESSAGES and WWV_FLOW_DEBUG_MESSAGES2. The data is exposed to the
developer via a single APEX Data Dictionary View: APEX_DEBUG_MESSAGES.
