1.2 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
    Use the Monitor Activity page 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
    View Schema Reports to review summaries of schema tablespace utilization and database privileges by schema, and a list of all database schemas available in the current workspace.

See Also:

"Viewing Workspace Dashboards," "Monitoring Activity Across a Development Instance," and "Creating Custom Activity Reports Using APEX_ACTIVITY_LOG" in Oracle Application Express App Builder User’s Guide

1.2.1 Accessing the Monitor Activity Page

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

To access the Monitor Activity page:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    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 organized by view, user, application, application and page, day, hour, and by interactive report.

    • Developer Activity - Offers reports of developer activity organized by developer, day, application, application changes, and day or month.

    • Sessions - Lists active sessions with the current workspace (report or chart).

    • Page View Analysis - Contains reports analyzing page views, such most viewed pages, page views by day, usage by day (chart), weighted page performance, and Websheet page views.

    • Environment - Contains reports of environments organized by user agent, browser, external clicks, or operating system.

    • Login Attempts - Offers reports listing login attempts, login attempts by authentication result, and a developer login summary.

    • Application Errors - Contains a report of application errors.

    • Workspace Schema Reports - Offers summaries of schema tablespace utilization, database privileges by schema, workspace schemas, and tablespace utilization.

    • Archived Activity Reports

      - Lists archived reports.
  3. Select a report to review.

1.2.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 Oracle Application Express.
    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.

1.2.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 Oracle Application Express.
    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.

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

See Also:

"Undertanding Session State Management" in Oracle Application Express App Builder User’s Guide

1.2.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 Application Express engine maintains a record in a database table in the Oracle Application Express 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.

1.2.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 Oracle Application Express.
    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.

1.2.5 Viewing Schema Reports

View Schema Reports to review summaries of schema tablespace utilization and database privileges by schema, and a list of all database schemas available in the current workspace.

To view Schema Reports:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    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)

    You can customize the appearance of the Database Privileges and Workspace Schemas reports using the Search bar at the top of the page.