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

3.16 Monitoring Activity Across an Instance

Monitor all end user and developer activity for an Oracle Application Express instance.

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.16.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.16.2 Accessing the Monitor Activity Page in Admistration Services

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

To access the Monitor Activity page in Admistration Services:

  1. Sign in to Oracle Application Express 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 - View activity summaries including:

      • Top Applications - Displays a bar graph of the most active applications based on the criteria specified.

      • Top Workspaces - Displays a bar graph the most active workspaces based on the criteria specified.

      • Activity Summary - Displays an activity summary including Total page view, Active apps, Active workspaces, Workspaces approved, Workspaces purged, Total apps, Active users, and Total workspaces.

    • 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 - View a 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.16.3 Viewing the Signup Survey Report

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

Note:

To ensure the security and performance of your development environment, this functionality is not available in Oracle APEX instances running in Oracle Cloud.
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 Oracle Application Express 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.16.4 Viewing the Backup Log

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

To view the Backup Log:

  1. Sign in to Oracle Application Express 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