Self Service Provisioning

Oracle Application Express can be deployed to enable users to request a workspace. A workspace provides access to an Oracle Application Express application development environment as well as access to one or more database schemas. The self-service model enables application development projects from multiple work groups to be consolidated within a single Oracle database.

Provisioning Modes

Oracle Application Express provides three provisioning modes:

• Manual - An administrator manually creates each workspace
• Request - Users follow a link displayed on the login page to request workspaces which administrators then review and approve or decline
• Email Verification - Users still submit requests but workspaces are only created after email verification by the user

Requesting Additional Service

Workspace Administrators can perform various duties including:

• Request an additional schema
• Request Storage
• Request Termination
• Define user account expiration and locking
• Enable / disable Application Builder, SQL Workshop, and Team Development

Workspace administrators can monitor workspace activity and resource utilization. Dashboards show key indicators organized by category and provide drill-downs to details. Summarized activity and resource consumption can also be subscribed to and received by email.

Oracle Application Express activity logs, which track detailed records of each page view and page post, are retained, by default, for a minimum of two weeks. Summarized performance information is maintained forever.

Oracle Application Express contains a separate Instance Administration interface which provides the ability to monitor and manage all workspaces as well as facilities to manage the instance as a whole.