14 Debugging an Application

This section describes approaches to debugging an application including running Oracle Application Express Advisor (Advisor), viewing Debug Mode, enabling SQL tracing, and viewing page reports. It also describes how to manually remove a control or a component to isolate a problem.

Topics:

• About Tuning Performance

• Running Advisor to Check Application Integrity

• Reviewing Session State

• Accessing Debugging Mode

• Enabling SQL Tracing and Using TKPROF

• Monitoring Application and Page Resource Use

• Viewing Page Reports

• Debugging Problematic SQL Queries

• Removing Controls and Components to Isolate a Problem