Enabling SQL Tracing and Using TKPROF

Tracing your session can be a very effective way to debug an application. From a database perspective, each page request is a single database session. If you enable SQL tracing, then Oracle HTML DB creates a temporary file you can then analyze using the TKPROF utility.

You enable SQL tracing in Oracle HTML DB by using f?p syntax to set the argument p_trace=YES. For example, to trace the display of page 1 in application 100 you would use the syntax:

http:/.../f?p=100:1&p_trace=YES

To use the TKPROF utility:

• Navigate to the directory in which the trace file is created.

• Type the following to view instructions about using TKPROF utility:

  tkprof help=yes