1. App Builder User's Guide
  2. Managing Application Performance
  3. Utilizing Logs and Reports

22.3 Utilizing Logs and Reports

Review application logs and reports to help identify problematic pages.

The Application Express engine records activity logs to capture usage and performance data. This information displays in various reports. If a particular page is accessed extensively or a page renders slowly then these reports can help you identify problematic pages.

You can then further analyze the problematic pages. For example, you can run a report query in SQL Developer to review the Explain Plan.

Tip:

Another method of determining expensive elements within a page or process is to review the Application Express Debug mode.

See Also:

Parent topic: Managing Application Performance

22.3.1 How to Manage Log Files

An Instance administrator can delete activity log files and manage the interval at which log file information is retained.

If you wish to keep the activity log files indefinitely, you must create a batch job to copy records from the activity log table to another table.

See Also:

"Managing Logs and Files" in Oracle Application Express Administration Guide

Parent topic: Utilizing Logs and Reports

22.3.2 Viewing the Application Dashboard Report

Learn how to view the Application Dashboard report.

To view the Application Dashboard:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Click Application Dashboard.

    The Application Dashboard appears and is divided into the following regions:

    • Application Overview list application details such as the ID, Parsing Schema, Alias, Group, and Pages.

    • Security lists the current authentication scheme, number of public and non public pages, and the number of authorization schemes used within the current application.

    • Templates contains links to reports of templates used within the current application.

    • Pages by Type lists pages by type.

    • Application Components contains links to reports of application-level controls and logic, including lists of values, tabs, lists, application items, application processes, and application computations.

    • Page Components contains links to reports of page-level controls and logic, including items, buttons, processes, regions, branches, validations, and dynamic actions.

  6. To view a specific report, click the number to the right of the component type or template.

Parent topic: Utilizing Logs and Reports

22.3.3 Accessing the Monitor Activity Page

Use the Monitor Activity page to view developer activity and application change information.

To access the Monitor Activity page:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click Monitor Activity.

    The Monitor Activity page appears and is divided into the following sections:

    • Page Views - Contains reports of page views organized by view, user, application, application and page, day, hour, and by interactive report.

    • Developer Activity - Offers reports of developer activity organized by developer, day, application, application changes, and day or month.

    • Sessions - Lists active sessions with the current workspace (report or chart).

    • Page View Analysis - Contains reports analyzing page views, such most viewed pages, page views by day, usage by day (chart), and weighted page performance.

    • Environment - Contains reports of environments organized by user agent, browser, external clicks, or operating system.

    • Login Attempts - Offers reports listing login attempts, login attempts by authentication result, and a developer login summary.

    • Application Errors - Contains a report of application errors.

    • Workspace Schema Reports and Other Reports - Offers summaries of schema tablespace utilization and database privileges by schema, workspace schemas, and report tablespace utilization.

  3. Select a report to review.

Parent topic: Utilizing Logs and Reports

22.3.4 Instance Activity Reports

Instance administrators are superusers that manage an entire hosted instance using the Application Express Administration Services application.

See Also:

Parent topic: Utilizing Logs and Reports