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 Workspace Dashboards", "Monitoring Activity Across a Development Instance", and "Creating Custom Activity Reports Using APEX_ACTIVITY_LOG in Oracle Application Express Application Builder User's Guide
To view developer activity and application change information from the Monitor Activity page:
Navigate to the Workspace home page.
Click the Administration icon.
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
Select a report to review.
The sections that follow details a few specific reports.
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:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
Under Developer Activity, select By Developer.
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. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.
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:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
Under Developer Activity, click By Day or By Day, Monthly View.
The Application Changes by Day page appears.
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. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.
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.
"What Is a Session?" in Oracle Application Express Application Builder User's Guide
To view active session details:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
Under Sessions, select Active Sessions.
You can customize the appearance of 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.
Click a session ID to view the Session Details page.
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:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
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.