../E12512-02.epub /> ../E12512-02.mobi />

Monitoring Activity within a Workspace

You can monitor developer activity and changes within your workspace by accessing the Monitor Activity page. The Monitor Activity page over twenty different reports that track changes to page views and applications, including reports on login attempts and external click counts.

Topics in this section include:

See Also:

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

Viewing Developer Activity and Application Change Information

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

  1. Navigate to the Workspace home page.

  2. From the Administration list, click Monitor Activity.

    The Monitor Activity page features activity reports divided into the following sections:

    • Page Views - Contains reports of page views organized by view, user, application, or application and page.

    • Page View Analysis - Contains reports analyzing page views, such as top page views by application.

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

    • Application Changes - Contains reports that track application changes by developer, day, or application.

    • Sessions - Lists active sessions with the current workspace.

    • Login Attempts - Contains reports listing login attempts.

      This report includes logins to:

      • Application Express environment through the login pages for Oracle Application Express Administration Services or Oracle Application Express

      • applications developed using Application Express that use the built-in session management facilities of Application Express

  3. Select a report to review.

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 home page.

  2. From the Administration list, click Monitor Activity.

  3. Under Application Changes, select By Developer.

  4. Make a selection from the Time list to specify a time frame and click Go.

  5. To view the data as a bar chart, select Changes by Developer Bar chart. To view the data as pie chart, select Changes by Developer Pie chart.

  6. To view additional details, select a user ID.

    A detailed report displays the application, date, component, and action by user.

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 home page.

  2. From the Administration list, click Monitor Activity.

  3. Under Application Changes, click By Day or By Day, Monthly View.

    The Application Changes by Day page appears.

  4. Select the appropriate report:

    • Month View offers a listing of application changes by day in a Calendar format.

    • Report includes a report of application changes by day.

    • Line Chart displays a line chart of application changes. By default, all developers are selected. To view only a specific developer, make a selection from the Developer list and click Go.

    • By Developer Report displays application changes by developer. Specify a time frame by making a selection from the Time list and clicking Go. To view additional details, select a developer. To download the report, click the Download link at the bottom of the report.

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.

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. A DBMS job runs every eight hours and purges session records older than 24 hours.

To view active session details:

  1. Navigate to the Workspace home page.

  2. From the Administration list, click Monitor Activity.

  3. Under Sessions, select Active Sessions.

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