1. Administration Guide
  2. Oracle APEX Administration Services
  3. Monitoring Activity Across an Instance

3.14 Monitoring Activity Across an Instance

Use the links on the Monitor Activity page to access various reports on application, developer, and session activity in all workspaces.

This section only highlights some of the reports available from the Monitor Activity page.

Note:

To ensure the security and performance of your development environment, some administration functionality is not available in Oracle APEX instances running in Oracle Cloud.

See Also:

Parent topic: Oracle APEX Administration Services

3.14.1 About Web Server Logs

URLs from the Web Server Access Logs and Error Logs can pinpoint the request to a specific application, page, and session.

For page GET requests, application, page and session details are part of APEX URL. For POST requests (such as when the page is submitted) or for AJAX requests, application, page and session information can be found in the p_context query parameter in the URL. Whether the Friendly URLs attribute is enabled determines what the p_context query parameter contains.

If the Friendly URLs is enabled p_context contains:

app-alias/page-alias/session-id

If the Friendly URLs is disabled (that is, you are using legacy f?p URL Syntax), p_context contains:

app_id:page_number:session_id

Note:

The location of the Web Server Access Logs and Error Logs depends on which Web Server you are using (for example, Apache, Tomcat, Jetty and so on). For more information, see the appropriate web server documentation .

See Also:

Understanding URL Syntax in Oracle APEX App Builder User’s Guide

Parent topic: Monitoring Activity Across an Instance

3.14.2 Accessing the Monitor Activity Page in Administration Services

Access the Monitor Activity page in Administration Services to view reports on application, developer, and session activity in all workspaces.

To access the Monitor Activity page in Administration Services:

  1. Sign in to Oracle APEX Administration Services.
  2. Click Monitor Activity.
    The Monitor Activity page appears.
  3. Click the appropriate link to view reports across all workspaces.

    The Monitor Activity page is divided into the following sections:

    • Activity Summary:

      • Administrator Digest - Displays various reports on instance, workspace and schema metrics as well as other user activity views within the instance.

      • Top Applications - Displays a graph and report of top applications.

      • Top Workspaces - Displays a bar graph of most active workspaces based on the criteria specified and a report workspace activity.

      • Activity Summary - Displays top applications and development activity from the daily summarized activity log.

    • Page Views - Dashboard, By View, By Application and User, By User, Page Views by User by Day, By Application, By Workspace, and By Workspace Faceted Search.

    • Service Requests - New Service Requests and Signup Survey.

    • Workspace Purge - Dashboard, Inactive Workspaces, Workspaces Purged, Workspaces that became Active, and Workspace Purge Log.

    • Logs - Mail Log, Web Service Activity Log, Automation Log, REST Synchronization Log, Jobs,Automatic File Delete Log, and Backup Log.

    • Environment Reports - By Operating System, By Browser, By User Agent, or By External Site.

    • Login Attempts - Login Attempts or Developer Last Login.

    • Calendar Reports - Workspace Last Used, Page Views by Day by Application and User, and User, and By Hour.

    • Developer Activity - Application Changes by Developer, Application Changes by Workspace, Native Component Utilization Chart, Native Component Utilization Report, and Data Loading Jobs.

    • Archived Activity - View archived activity reports.

Parent topic: Monitoring Activity Across an Instance

3.14.3 Viewing the Administrator Digest

Access the Administrator Digest dashboard to view the key instance activity metrics and how these metrics change over time.

The Administrator Digest page gathers information about workspaces, applications, schemas, workspace users, user and system scheduler jobs, and database links.

To access the Administrator Digest page:

  1. Sign in to Oracle APEX Administration Services.
  2. Click Monitor Activity.
    The Monitor Activity page appears.
  3. Click Administrator Digest.

    The Administrator Digest page features the following icons, charts, and links:

    • Instance Metrics - Displays a report in which each record includes the overall metrics for the entire instance in a day (for example, created or removed workspaces and database links).

    • Workspace Metrics - Displays a report in which each record includes the overall activity at the workspace level in a day (for example, user accounts, distinct users, page events, login attempts, created or removed applications, web service requests, and so on).

    • Schema Metrics - Displays a report in which each record includes the overall metrics at the schema level in a day (for example, database links, different aggregations for user scheduler jobs, and information about the used versus free space).

    • Summary Dashboard - Displays a series of reports and charts incorporating the main activities over all workspaces within a certain time interval. To change the number of days, select a new value from the Since list and click Set.

    • Additional Metrics - Additional regions feature charts that display the metric aggregations within the default reporting period. Click the right arrow (>) to view more details. Available regions include:

      • Workspaces
      • Applications
      • Workspace Users
      • User Scheduler Jobs
      • System Scheduler Jobs
      • Database Links
      • Workspaces with 10% Free Space Remaining, where percentage value can be updated using the Instance Parameter: WORKSPACE_FREE_SPACE_LIMIT
    • Top Activity - View activity reports for Top Workspaces, Top Applications, or Top Users.

Parent topic: Monitoring Activity Across an Instance

3.14.4 Viewing the Signup Survey Report

View the Signup Survey report to view the survey questions, answers, and the number of responses.

Instance administrators can also include survey questions users must complete when running the New Service Signup Wizard.

To view the Signup Survey report:

  1. Sign in to Administration Services.
  2. Click Monitor Activity.
    The Monitor Activity page appears.
  3. Under Service Requests, click the Signup Survey.

    The Signup Survey appears displaying the survey questions, answers, and the number of responses.

  4. To clear the Signup Survey report, click Reset Report.

See Also:

Defining a Service Signup Wizard

Parent topic: Monitoring Activity Across an Instance

3.14.5 Viewing the Backup Log

Monitor the performance of a backup job by reviewing the Backup Log.

The Backup Log reports when a backup job ran, the number of applications backed up by the job, and the elapsed time required to backup the applications.

To view the Backup Log:

  1. Sign in to Administration Services.
  2. Click Monitor Activity.
    The Monitor Activity page appears.
  3. Under Logs, click the Backup Log.

    The Backup Log appears displaying when a backup job ran, the number of applications backed up by the job, and the elapsed time required to backup the applications.

    The elapsed time displays as Hours, Minutes, Seconds, Milliseconds (HH:MI:SS.FF). For example, a job with a duration of 00:00:00.812 took eight-hundred-twelve milliseconds. A job with a duration of 00:02:16.956 took two minutes, 16 seconds, nine-hundred-fifty-six milliseconds.

  4. Click the Batch number to display the details.
    The Backup Log dialog appears displaying the IDs of the applications backed up in the job and the duration.
  5. To remove Backup Log data, click Truncate.
    All Backup Log information is immediately removed.

See Also:

Parent topic: Monitoring Activity Across an Instance