Databases Reference
In-Depth Information
Figure 6-18.
Debug data for the altered version of an interactive report
Figure 6-18 shows the detailed debug data for the same Interactive Report region
after
a user has
made changes to the report, as indicated in Figure 6-19. The changes indicate that we are filtering the
ASSIGNED_TO and grouping by the STATUS.
•
Line 35 indicates the start of the region.
•
Line 38 lists the columns that will be displayed.
•
Line 40 shows the base SQL statement.
•
Line 41 shows the value of the APXWS_EXPR_1 bind variable, as it will be used in
the SQL statement.
•
Line 42 shows the value of the APXWS_MAX_ROW_CNT bind variable, as it will be
used in the SQL statement.
With this debug data you have enough information to not only troubleshoot, but also examine the
potential performance of the query that was generated.
Figure 6-19.
The filters applied to the altered report
APEX Debugging API
Not only does APEX provide you with a method to interactively debug your application pages, it also
provides a full API that allows you to instrument your own code and even turn on debugging
