23 Debugging an Application

Learn about best practices for debugging an Oracle Application Express application.

• Running Advisor to Check Application Integrity
  Use Oracle Application Express Advisor (Advisor) to check the integrity and quality of your Oracle Application Express application.
• Reviewing Session State
  View current session state for your application by clicking the Session link on the Runtime Developer Toolbar.
• About Monitoring Application and Page Resource Use
  Query the V$SESSION and V$SQLAREA views to monitor application and page resource use..
• Enabling SQL Tracing and Using TKPROF
  Enable SQL tracing and then analyze the temporary file Oracle Application Express creates using the TKPROF utility.
• Utilizing Debug Mode
  Use Debug mode to track down unexpected application behavior.
• About Removing Controls and Components to Isolate a Problem
  If you have problems running a page, try removing controls and components one at a time.

See Also:

• "APEX_DEBUG" in Oracle Application Express API Reference

• "Managing Application Performance"