2.15 Monitoring Activity Within a Workspace

Monitor developer activity and changes within a workspace by accessing the Monitor Activity page.

The Monitor Activity page features links to numerous reports that track page views, developer activity, active sessions and also view page view analysis reports, environment reports such as browser usage and click counts, and login reports. This section only describes a few reports in detail.

• Accessing the Monitor Activity Page in Workspace Administration
  Use the Monitor Activity page in Workspace Administration to view developer activity and application change information.
• Viewing Application Changes by Developer
  Access the Application Changes by Developer report displays the number of pages changed by each developer and offers a graphical representation of the information in either a bar chart or pie chart format.
• Viewing Application Changes by Day
  Access the Application Changes by Day report displays a summary of the number of application changes by day. You have the option to view this information by month, as a line chart, or by developer.
• Viewing Active Sessions
  A session is a logical construct that establishes persistence (or stateful behavior) across page views. Use the Active Sessions report to view active sessions in the current workspace.
• Viewing Schema Reports and Other Reports
  View reports that summarize of schema tablespace utilization including Schema Tablespace Utilization, Database Privileges by Schema, Workspace Schemas, Report Tablespace Utilization, and Web Service Activity Log.

See Also:

• Monitoring Activity Across an Instance

• Viewing Workspace Dashboards

• Creating Custom Activity Reports Using APEX_ACTIVITY_LOG in Oracle APEX App Builder User’s Guide

2.15.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, By Hour, and By Interactive Report.

   • 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 - Contains the Application Errors.

   • 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.

2.15.2 Viewing Application Changes by Developer

Access the Application Changes by Developer report displays the number of pages changed by each developer and offers a graphical representation of the information in either a bar chart or pie chart format.

To view application changes by developer:

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.
3. Under Developer Activity, select By Developer.
4. Make a time selection from the Since list, an application (if applicable), and click Set.

   You can customize the appearance of the page using the Search bar at the top of the page.

2.15.3 Viewing Application Changes by Day

Access the Application Changes by Day report displays a summary of the number of application changes by day. You have the option to view this information by month, as a line chart, or by developer.

To view application changes by day:

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.
3. Under Developer Activity, click By Day.

   The Application Changes by Day page appears.

4. Make a time selection from the Since list, an application (if applicable), and click Set.

   You can customize the appearance of the page using the Search bar at the top of the page.

2.15.4 Viewing Active Sessions

A session is a logical construct that establishes persistence (or stateful behavior) across page views. Use the Active Sessions report to view active sessions in the current workspace.

• What is an Active Session?
  An active session is a session that has not yet been purged from the sessions table.
• Viewing the Active Sessions Report
  View the Active Sessions report to view active sessions in the current workspace.

See Also:

Understanding Session State Management in Oracle APEX App Builder User’s Guide

2.15.4.1 What is an Active Session?

An active session is a session that has not yet been purged from the sessions table.

Whenever an application is run, the APEX engine maintains a record in a database table in the APEX schema. This table records a numeric identifier (or session ID), the authenticated (or public) user identifier, the creation date, and other information. The session is the key record that enables session state, or persistence, across page requests. By viewing the Active Sessions report, a developer or administrator can see who has been using applications in a workspace. An active session is a session that has not yet been purged from the sessions table. An expired session is a session which has been existing longer than its maximum lifetime or which has not been used for longer than its maximum idle time. A DBMS job runs every hour and purges expired sessions.

2.15.4.2 Viewing the Active Sessions Report

View the Active Sessions report to view active sessions in the current workspace.

To view active session details:

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.
3. Under Sessions, select Active Sessions.

   You can customize the appearance of the page using the Search bar at the top of the page.

4. Click a session ID to view the Session Details page.

2.15.5 Viewing Schema Reports and Other Reports

View reports that summarize of schema tablespace utilization including Schema Tablespace Utilization, Database Privileges by Schema, Workspace Schemas, Report Tablespace Utilization, and Web Service Activity Log.

To view Schema Reports:

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.
3. Under Workspace Schema Reports, click one of the following reports:

   • Schema Tablespace Utilization

   • Database Privileges by Schema

   • Workspace Schemas

   • Report Tablespace Utilization (popup)

   • Web Service Activity Log

   • Archive of Purged Task Files

   Note:

   With the exception of Report Tablespace Utilization, you can search or customize the reports using the Search bar and Actions menu at the top of the page.