3.5 Utilizing App Administration

Administrators use App Administration to manage and monitor productivity and sample apps in their workspace.

See Also:

"Workspace and Application Administration" in Oracle Application Express Administration Guide

3.5.1 Making a Service Request

Create a service request for additional storage or terminate a workspace.

Tip:

Only users with administrator rights can access this functionality.

To make a service request for more storage or to terminate service:

  1. Sign in to Oracle Application Express.
  2. Click App Gallery.
  3. Click Administration.
  4. Click Make a Service Request.
  5. To identify the type of service you would like to request, select one of the following:
    • Request Schema

    • Request Storage

    • Request Termination

      Tip:

      To see the amount of free space available in a workspace, expand Tablespace Utilization and select Detailed Tablespace Utilization Report (may take several seconds).

  6. Follow the on-screen instructions.

3.5.2 Setting Workspace Preferences

Configure account login controls such as account expiration and locking, maximum login failures, and end user account lifetime (in days).

Tip:

Only users with administrator rights can access this functionality.

.

To set workspace preferences:

  1. Sign in to Oracle Application Express.

  2. Click App Gallery.

  3. Click Administration.

  4. Click Set Workspace Preferences.

  5. Under Account Login Control:

    Tip:

    To learn more about any attribute, see field-level Help.

    1. Account Expiration and Locking - Make a selection to determine whether Application Express end user accounts can be expired or locked. This feature applies only to end-user accounts created using the Application Express user management interface.

    2. Maximum Login Failures Allowed - Enter a positive integer for the maximum number of consecutive unsuccessful authentication attempts allowed before an end-user account is locked. If you do not specify a value in this field, the instance-level setting for Maximum Login Failures Allowed is used.

    3. End User Account Lifetime (days) - Enter a positive integer for the maximum number of days an end-user account password may be used before the account expires. If you do not specify a value in this field, the instance-level setting for Account Password Lifetime is used.

  6. Click Apply Changes.

3.5.3 Managing Users

Administrators in a Productivity and Sample Apps Only workspace can create new user accounts, manage existing user accounts, and change user passwords.

A Productivity and Sample Apps Only workspace enables developers to share applications with other developers and administrators. It does not include any access to development tools such as App Builder or SQL Workshop. A Productivity and Sample Apps Only workspace includes the Apps page and the App Administration page.

Tip:

Only users with administrator rights can access this functionality. This option is only available in a Productivity and Sample Apps Only workspace, but not in full workspace.

To manage users in a Productivity and Sample Apps Only workspace:

  1. Sign in to the Productivity and Sample Apps Only workspace.
  2. Click Administration.
  3. Click Manage Users.

    Managing users works the same in a Productivity and Sample Apps Only workspace as it does at the workspace-level.

3.5.4 Managing Saved Interactive Reports

View and delete saved interactive reports created by users of productivity and sample apps.

To manage saved interactive reports:

  1. Sign in to Oracle Application Express.
  2. Click App Gallery.
  3. Click Administration.
  4. Click Saved Reports.

    Managing saved interactive reports works the same in a Productivity and Sample Apps Only workspace as it does at the workspace-level.

See Also:

"Viewing and Deleting Saved Interactive Reports" in Oracle Application Express Administration Guide

3.5.5 Managing Interactive Report Subscriptions

View and manage interactive report subscriptions created by users of apps.

To manage interactive report subscriptions:

  1. Sign in to Oracle Application Express.
  2. Click App Gallery.
  3. Click Administration.
  4. Click Subscriptions.

    Managing interactive report subscriptions works the same in a Productivity and Sample Apps Only workspace as it does at the workspace-level.

See Also:

"Managing Interactive Report Subscriptions" in Oracle Application Express Administration Guide

3.5.6 Viewing Activity Reports

View a monthly calendar of app activity that details users and total page views by day.

To view App Activity report:

  1. Sign in to Oracle Application Express.
  2. Click App Gallery.
  3. Click Administration.
  4. Click App Activity.

    A monthly calendar of application activity appears.

3.5.7 Viewing Page Views

View a report of app page views detailing the app, page, user, and elapsed time.

To view the Page View report:

  1. Sign in to Oracle Application Express.
  2. Click App Gallery.
  3. Click Administration.
  4. Click Page Views.

3.5.8 Viewing Top Users

View a report of app page views aggregated by user.

To view the Top Users report:

  1. Sign in to Oracle Application Express.
  2. Click App Gallery.
  3. Click Administration.
  4. Click Top Users.