24 Debugging an Application

Learn about best practices for debugging an Oracle APEX application.

• Running Advisor to Check Application Integrity
  Use Oracle APEX Advisor (Advisor) to check the integrity and quality of your APEX 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 APEX 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.