12 Debugging an Application

This section describes approaches to debugging an application including 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.

This section contains the following topics:

• About Tuning Performance

• Reviewing Session State

• Accessing Debug Mode

• Enabling SQL Tracing and Using TKPROF

• Monitoring Application and Page Resource Use

• Viewing Reports

• Debugging Problematic SQL Queries

• Removing Controls and Components to Isolate a Problem