Previous Next JavaScript must be enabled to correctly display this content

## 23.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.

- Accessing the Monitor Activity Page in Workspace Administration
  Use the Monitor Activity page in Workspace Administration to view developer activity and application change information.
- About Managing Log Files
  An Instance administrator can delete log files and manage the interval at which log file information is retained.
- Viewing the Dashboard Report
  The Dashboard report displays metrics about applications in your workspace.
- Instance Activity Reports
  Instance administrators are superusers that manage an entire hosted instance using the APEX Administration Services application.

See Also:

- APEX_DEBUG in Oracle APEX API Reference
- Utilizing Debug Mode

Parent topic: Managing Application Performance

### 23.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. Select the Administration menu and then 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 including: 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

### 23.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

### 23.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

### 23.3.4 Instance Activity Reports

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

See Also:

- Monitoring Activity Across a Development Instance in Oracle APEX Administration Guide
- About Oracle APEX Administrator Roles

Parent topic: Utilizing Logs and Reports