 |
|
Oracle Tips by Burleson |
Displaying Debug Information
To display
debug information, click on the Debug link in the developer toolbar.
The Debug argument in the URL can also be used. It is the 5th
argument, as shown here:
http://localhost:7777/pls/hdb20/f?p=103:2300:10221629323751869385::YES
Looking at the output from a session in debug mode
reveals several pieces of information. The following debug
information is from the same page used in Figure 12.8 in this text.
From the debug output, the following becomes apparent:
-
There is some PL/SQL running in the BEFORE_HEADER
processing point.
-
In the AFTER_HEADER computation point, there is a
static computation setting the session state for page item
P2300_REGION_1.
-
The AFTER_HEADER processing point has another
PL/SQL procedure running.
-
The elapsed time since the page rendering began
can be seen. The 0.02 and 0.04 are how many seconds it took to get
to this point in the page rendering process.
0.02: Fetch session header
information
0.02: ...fetch page attributes: f103, p2300
0.02: Fetch session state from database
0.02: Branch point: BEFORE_HEADER
0.02: Fetch application meta data
0.02: Computation point: BEFORE_HEADER
0.02: Processing point: BEFORE_HEADER
0.02: ...PLSQL (BEFORE_HEADER) begin htp.p( 'BeforeHeader Process
Point'
); end;
BeforeHeader Process Point
0.02: Show page template header
0.02: Computation point:
AFTER_HEADER
0.02: ...performing static computation
0.02: ...P2300_REGION_1 session state saving same value: "Must be set
with
Before Header or After Header."
0.02: ...performing static computation
0.02: ...P2300_AFTER_HEADER session state saving same value: "Must be
set
with Before Header or After Header."
0.02: Processing point: AFTER_HEADER
0.02: ...PLSQL (AFTER_HEADER) begin htp.p( 'AfterHeader Process Point'
);
end;
AfterHeader Process Point
0.04: Region: After Header
The
above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create Dynamic
Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
