1.2 Monitoring Activity Within a Workspace

Administrators can 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.

1.2.1 Accessing the Monitor Activity Page

To view developer activity and application change information from the Monitor Activity page:

  1. Navigate to the Workspace Administration page. See "Accessing the Workspace Administration Page."

    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 and database privileges by schema, workspace schemas, and report tablespace utilization.

  3. Select a report to review.

1.2.2 Viewing Application Changes by Developer

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. See "Accessing the Workspace Administration Page."

    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

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. See "Accessing the Workspace Administration Page."

    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. The Active Sessions report lists active sessions with the current workspace.

See Also:

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

1.2.4.1 What is an Active Session?

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

To view active session details:

  1. Navigate to the Workspace Administration page. See "Accessing the Workspace Administration Page."

    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

Schema Reports offer 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. See "Accessing the Workspace Administration Page."

    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.