Use SQL Tracing and TKPROF to Debug Application Sessions

When you enable SQL tracing, a temporary file of session activity is created.

You can use TKPROF utility to analyze the file. See Enabling SQL Tracing and Using TKPROF in Oracle Application Express Application Builder User’s Guide.