14.2 Running Advisor to Check Application Integrity

The Oracle Application Express Advisor (Advisor) enables you to check the integrity and quality of your Oracle Application Express application. Advisor functions like a compiler or LINT and flags suspicious behavior or errors. Running Advisor checks the integrity of your application based on the underlying metadata.

Topics:

14.2.1 About Oracle Application Express Advisor

Before deploying your application, you can use the Oracle Application Express Advisor to perform various sanity checks on your application. The Advisor checks for errors, security issues, performance bottlenecks, usability and quality assurance.

14.2.2 Running Advisor on an Entire Application

To run Advisor on an entire application:

  1. Navigate to the appropriate application:

    1. On the Workspace home page, click the Application Builder icon.

      The Application Builder home page appears.

    2. Select the application.

      The Application home page appears.

  2. Click Utilities.

  3. Click Advisor.

    The Advisor page appears.

    Description of debug_advisor.gif follows
    Description of the illustration debug_advisor.gif

  4. Under Checks to Perform, review the selected checks. Enable and disable check boxes as appropriate.

  5. Click Perform Check at the top of the page.

    A Results page appears. Current Advisor settings are used next time the check is performed.

  6. To remove any Advisor changes you have made, under Tasks select Remove My Preferences.

  7. To run Advisor again, click Perform Check.

14.2.3 Running Advisor on a Single Page

To run Advisor on a single page:

  1. Navigate to the appropriate application:

    1. On the Workspace home page, click the Application Builder icon.

      The Application Builder home page appears.

    2. Select the application.

      The Application home page appears.

    3. Select the page.

      The Page Definition page appears.

  2. Click Utilities.

    The list of utility options displays.

  3. Click Check.

    The Results page appears. Result reports are generated using the last Advisor settings.

  4. To change settings, click Change Settings.

    The Advisor page appears.

  5. Under Checks to Perform, review the selected checks. Enable and disable check boxes as appropriate.

  6. To run the check again, click Perform Check at the top of the page.

    A Results page appears. Current Advisor settings are used next time the check is performed.

  7. To filter results, enable and disable check boxes under Filter Results and click Apply Filter.

  8. To re-run the Advisor and see if reported problems are fixed, click Check Again.