Previous Next JavaScript must be enabled to correctly display this content

## 2.16 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

Parent topic: Workspace and Application Administration

### 2.16.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: Monitoring Activity Within a Workspace

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

Parent topic: Monitoring Activity Within a Workspace

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

Parent topic: Monitoring Activity Within a Workspace

### 2.16.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 Session Detail report to review session information and configure Debug Level and Trace Mode for the an active session.

See Also:

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

Parent topic: Monitoring Activity Within a Workspace

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

Parent topic: Viewing Active Sessions

#### 2.16.4.2 Viewing the Active Sessions Report

View the Session Detail report to review session information and configure Debug Level and Trace Mode for the an active session.

To view the Session Detail report:

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.
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.
   Use the Session Detail page to inspect session information and control and configure Debug mode.
5. Session Attributes - View active session attributes. Configurable attributes include:

   - Enable Debug - Enable and disable Debug mode. Options include:

     - Disabled - Disables Debug mode.
     - Error (LEVEL1) - Logs error messages.
     - Warn (LEVEL2) - Logs warning messages.
     - Info (LEVEL4) - Logs informational messages. This is the default level when debugging is enabled but not set to a specific level.
     - Application Enter (LEVEL5) - Logs messages when entering (starting) and leaving (finishing) specific methods and operations specific to the application.
     - Application Trace (LEVEL6) - Logs detailed information about methods and operations specific to the application.
     - APEX Enter (LEVEL8) - Logs messages when entering (starting) and leaving (finishing) specific methods and operations from the APEX engine.
     - APEX Trace (LEVEL9) - Logs detailed information about methods and operations from the APEX engine.

       Note:

       APEX engine will generate a substantial amount of messages at higher debug levels, which will impact application performance and require more time to review and analyze. Oracle recommends debugging applications at the Application Trace (LEVEL6) level or lower unless directed by Oracle Support.

   - Trace Mode - Options include:

     - Disabled - Disables Trace mode.
     - SQL Trace - Creates a temporary file you can then analyze using the TKPROF utility.
6. Click Apply Changes to update the session.
7. The Session Details report includes the following additional session information:
   - Page Views
   - Background Processing
   - Session State Item Values
   - Browser Information

Parent topic: Viewing Active Sessions

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

   The Workspace Administration home page appears.

2. Click Monitor Activity.
3. Under Workspace Schema & Other 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.

Parent topic: Monitoring Activity Within a Workspace