Skip Headers
Oracle® Application Express Administration Guide
Release 4.1

Part Number E21678-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 features links to over thirty reports that track page views, developer activity, active sessions, login attempts, environment, application errors, and workspace schemas. Note that this section only describes a few reports in detail.

Topics:

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. Click the Administration icon.

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

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

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

    • Sessions - Lists active sessions with the current workspace.

    • Login Attempts - Offers reports listing login attempts.

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

    • Application Errors - Contains a report of application errors.

    • Workspace Schema Reports - Offers summaries of schema tablespace utilization and database privileges by schema and a list of all database schemas available in the current workspace

  4. Select a report to review.

    The sections that follow details a few specific reports.

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. Click the Administration icon.

  3. Click Monitor Activity.

  4. Under Developer Activity, select By Developer.

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

    You can customize the appearance the page using the Search bar at the top of the page. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.

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. Click the Administration icon.

  3. Click Monitor Activity.

  4. Under Developer Activity, click By Day or By Day, Monthly View.

    The Application Changes by Day page appears.

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

    You can customize the appearance the page using the Search bar at the top of the page. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.

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. Click the Administration icon.

  3. Click Monitor Activity.

  4. Under Sessions, select Active Sessions.

    You can customize the appearance the page using the Search bar at the top of the page. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.

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

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

  2. Click the Administration icon.

  3. Click Monitor Activity.

  4. 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. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.