Databases Reference
In-Depth Information
These figures are particularly useful in that they allow you to zoom in on the pages that need
performance optimization. For instance, the following is a series of steps you can adopt as a strategy for
optimization:
5.
Sort all pages by Median Elapsed time, and take note of all the pages that
exceed a certain threshold. Consider deriving that threshold from your
enterprise objectives. For instance, your Quality of Service statement might
include delivering every page to your end user in less than three seconds. Such
an objective will let you narrow down to a smaller and more manageable
subset of pages for optimization.
Tip
It's interesting to note that public tenders issued by the Government of Singapore for IT projects typically
outline the three-second maximum response time as one of the requirements for web-based applications.
6.
Review the Page Events values. The Median Elapsed time alone is not a good
indicator for the performance of the page. Looking at the Page Events column
will let you make a better assessment, since the number of page events roughly
correlates with the complexity of the page. For instance, a page that takes three
seconds to load might actually be more performance-effective than a page that
takes one second to load if that first page has 20 events and the second page
has 1 event.
7-3. Measuring Region Performance in APEX
Problem
You now know the average elapsed time taken for each page. You want to drill down further into the
performance of each individual region in a particular page. As in the previous recipe, your goal is to
focus your optimization efforts on those pages and regions consuming the most time.
Solution
To measure region performance, please follow these steps:
1.
Log in to APEX and open any application that contains a report. (To create a
report page, please see Recipe 2-2). Navigate to the Page Rendering view of the
report page.
2.
Expand the Regions node, and right-click on any region under this node. Click
the Edit menu item in the pop-up menu (as shown in Figure 7-4).
