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 Oracle APEX 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 APEX Debug mode.

See Also:

Parent topic: Managing Application Performance

22.3.1 Accessing the Monitor Activity Page in Workspace Administration

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

To access the Monitor Activity page in Workspace Administration:

  1. Navigate to the Workspace Administration page:
    1. Sign in to APEX.
    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 including By View, By User, By User and Hour,By Application, By Application and Page, By Day, and By Hour.

    • Developer Activity - Offers reports of developer activity organized such as By Developer, By Developer Bar Chart, By Developer by Hour, By Day, By Application, Application Changes (detailed), By Day, Monthly View, and Component Utilitzation Chart.

    • Sessions - Lists active sessions with the current workspace such as Active Sessions and Bar Chart of Active Session by Hour.

    • Page View Analysis - Contains reports analyzing page views, such as Most Viewed Pages over All Applications, Monthly Calendar of Page Views by Day, Line Chart of Usage by Day, and By Weighted Page Performance.

    • Environment - Contains reports of environments including By User Agent, By Browser, By External Click, and By Operating System.

    • Login Attempts - Offers reports listing login attempts such as Login Attempts, Login Attempts by Authentication Result, and Developer Login Summary.

    • Application Errors - Links to the Application Errors report.

    • Workspace Schema Reports and Other Reports - Includes the following reports: Schema Tablespace Utilization, Database Privileges by Schema, Workspace Schemas, Report Tablespace Utilization, Web Service Activity Log, and Archive of Purged Task Files.

    • Archived Activity Report - Includes the following reports: By Application by Month, By Application by Day, Application Hash by Day, By Application, and Chart of Workspace Activity by Day.

  3. Select a report to review.

Parent topic: Utilizing Logs and Reports

22.3.2 About Managing Log Files

An Instance administrator can delete 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:

Configuring and Deleting Logs and Log Entries in Oracle APEX Administration Guide

Parent topic: Utilizing Logs and Reports

22.3.3 Viewing the Dashboard Report

The Dashboard report displays metrics about applications in your workspace.

To view the Dashboard:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Click Dashboard.

    The Dashboard appears and features the following regions:

    • Applications - Count of applications in the current workspace.

    • Pages - Count of pages in the current workspace.

    • Developer Activity (Last 2 Days)

    • Page Events

    • Page Count by Application

    • Most Active Pages

    • Native Region Component Utilization

Parent topic: Utilizing Logs and Reports

22.3.4 Instance Activity Reports

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

See Also:

Parent topic: Utilizing Logs and Reports