Databases Reference
In-Depth Information
down into Views 131, 132 and 134 by clicking on the View Identifier link shows us that each of these
represents the SHOW phase of page processing. View 132, on the other hand, represents the ACCEPT
phase.
We know this by looking at the first line of the debug output, where we see either the word SHOW or
ACCEPT.
Looking back at the overview report, there is no way to know by viewing only the overview data
which views represent a SHOW phase and which represent an ACCEPT phase. While this is slightly
annoying and unintuitive, don't be too disturbed by it. We'll see later that we have access directly to the
detail data via an APEX Data Dictionary view and there are things we can do there to identify one from
the other.
The details page shows the data in two formats. First is the histogram graph across the top of the
page. In this histogram the bars represent the duration of each step in relation to the single step with the
largest duration. The second is the actual report that shows the details of what was executed during the
phase execution.
Hovering over any of the bars in the histogram with your mouse (as shown in Figure 6-9) will show
information about the step represented by that bar. Clicking on that bar will scroll the screen so that the
detail line represented by the bar will come into view in the window.
Figure 6-9.
View Detail Histogram showing hover hint
The detail report is, again, an interactive report allowing you to create filters and manipulate the
data in many different ways. The first row of the report, when sorted by Elapsed time or Row, will
identify the base information about the current view, including the phase, application number, page
number, workspace, request, and session. This will help you identify exactly what you are looking at. The
subsequent lines show the individual steps taken to complete the phase being executed.
The detail report also has a column labeled Graph that mirrors the histogram that appears at the top
of the page. This visual clue will help you scroll down the detail report and easily identify those steps that
took the most time during the phase execution.
The actual detailed steps that appear will vary from page to page and also between the ACCEPT and
SHOW phases. However, they will generally conform to the broad sections outlined earlier in Figure 6-2.
Navigation between the different detail views can be achieved via the navigation region at the top of
the detail page as presented in Figure 6-10. If you know the View ID, you can simply type it in the Page
View Identifier field at the top of the detail view page and click the Set button. If you want to return to
the high-level view page, click the Select Page View Identifier button.
Figure 6-10
. The Debug View Navigation region
