1.13 Viewing Workspace Dashboards

This section describes how to use the Dashboard page to view details about the current workspace and monitor overall workspace activity.

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

1.13.1 Accessing the Workspace Dashboard

To view the Administration Dashboard:

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

    The Workspace Administration home page appears.

  2. Click the Dashboards icon.

    The Dashboard page appears.

  3. Select a dashboard to review. Options include:

1.13.2 Workspace Dashboard

The Administration Dashboard offers a summary of workspace attributes and statistics, including:

  • Service - Lists the workspace name, the number and type of applications, SQL scripts, schemas, and open service requests.

  • Available Schemas - Lists schemas within the current workspace.

  • Files - Details the space used by specific file types.

  • Recent Service Requests lists pending service requests.

1.13.3 Users Dashboard

The Users Dashboard displays a summary of workspace users, including:

  • Your Account - List your username, associated user roles, workspace name, creation date, and email address.

  • Workspace Users - Lists statistics about all users in the current workspace.

  • User Groups - Lists are currently defined user groups.

  • Recently Created - Lists recently created users.

  • User Status - Lists valid passwords, expired passwords, locked accounts, unlocked accounts, and any accounts for which no email address is defined.

See Also:

"Managing Users in a Workspace"

1.13.4 Activity Dashboard

The Activity Dashboard displays a summary of workspace user activity for the selected time frame, including:

  • Top Users - Lists the most active users in the workspace.

  • Top Applications - Lists applications having the most activity.

  • Top Pages - Lists the application pages having the most activity.

  • Recent Logins- Shows the time and date a user authenticated to an application.

  • Recent Errors - Lists errors that have occurred in the current workspace from the Application Express activity log.

1.13.5 Developer Activity Dashboard

The Developer Activity Dashboard displays a summary of developer application and page changes for the selected timeframe, including:

  • Top Developers - Lists the most active developers in the workspace.

  • Top Applications - Lists the applications having the most developer activity.

  • Top Pages - Lists the application pages having the most developer activity.

  • Recent Changes - Lists changes by application, page, and user.

  • Recent Application Edits - Lists edits by application.

1.13.6 Performance Dashboard

The Performance Dashboard displays a report of pages having the worst page performance. Page performance is calculated by multiplying page events by median elapsed server page generation time. Page events include page gets, page posts, and partial page gets.

1.13.7 Websheets Dashboard

The Websheets Dashboard displays a websheet activity for the selected time frame. Sections include:

  • Workspace Summary

  • Recent Views

  • Recently Created

  • Recently Updated

1.13.8 Applications Dashboard

The Applications Dashboard displays a summary of applications in the current workspace. Sections include:

  • Summary - Lists the number of applications, pages, and workspace themes.

  • Application Groups - Lists defined application groups.

  • Recently Created - Lists recently created applications.

  • Defaults - Lists defined defaults.

1.13.9 Database Dashboard

The Database Dashboard displays a summary of database objects by schema. Row counts are based on database table statistics. Sections include:

  • Recently Modified Program Units

  • Object Counts

  • Recently Created Tables

  • Top Tables by Row Count