Viewing Workspace Dashboards

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 App Builder User’s Guide

Accessing the Workspace Dashboards

Use the Dashboard page to view details about the current workspace and monitor overall workspace activity.

To view the Administration Dashboard:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click the Dashboards icon.

    The Dashboard page appears.

  3. Select a dashboard to review:

Workspace Dashboard

View a summary of workspace users. Activity attributes display based on the selected time frame.

The Workspace 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.

Users Dashboard

View a summary of workspace users. Activity attributes display based on the selected time frame.

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.

Activity Dashboard

View a summary of workspace user activity for the selected time frame.

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.

Developer Activity Dashboard

View a summary of developer application and page changes for the selected time frame.

The Developer Activity dashboard displays a summary of developer application and page changes for the selected time frame, 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.

Performance Dashboard

View pages having the worst page performance.

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.

Websheets Dashboard

View a summary of websheet activity for the selected timeframe.

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

  • Workspace Summary

  • Recent Views

  • Recently Created

  • Recently Updated

Applications Dashboard

View a summary of database applications.

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.

Database Dashboard

View a summary of database objects by schema. Row counts are based on database table statistics.

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