1/34

Contents

Title and Copyright Information

Preface

• Topic Overview
• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 4.2

1 Workspace and Application Administration

• 1.1 About the Workspace Administration Page
  • 1.1.1 Accessing the Workspace Administration Page
  • 1.1.2 Resetting Your Password from the Administration Page
  • 1.1.3 Viewing the Application Express Product Information Page
  • 1.1.4 Managing Files in the Export Repository
  • 1.1.5 Managing Websheet Database Objects
• 1.2 About the Manage Service Page
  • 1.2.1 Accessing the Manage Service Page
  • 1.2.2 Managing Interactive Report Settings
• 1.3 Making a Service Request
  • 1.3.1 Requesting a New Schema, More Storage, or Terminating Service
  • 1.3.2 Determining the Amount of Space Available in Your Workspace
  • 1.3.3 Requesting Another Workspace
• 1.4 Configuring Workspace Preferences
  • 1.4.1 Enabling Account Login Controls for a Workspace
  • 1.4.2 Enabling Application Builder Development
  • 1.4.3 Enabling SQL Workshop
  • 1.4.4 Disabling PL/SQL Program Unit Editing for a Workspace
  • 1.4.5 Managing Team Development
• 1.5 Defining a Workspace Announcement
• 1.6 About the Workspace Utilization Report
  • 1.6.1 Viewing and Emailing the Workspace Summary Report
• 1.7 Understanding User Roles
• 1.8 Managing Application Express Users
  • 1.8.1 Creating New User Accounts
  • 1.8.2 Creating Multiple Users Simultaneously
  • 1.8.3 Editing Existing User Accounts
  • 1.8.4 Deleting or Locking User Accounts
  • 1.8.5 Deleting Multiple Users at Once
  • 1.8.6 Changing an End User Password
  • 1.8.7 Viewing the Users Dashboard
  • 1.8.8 Using Groups to Manage Application Express Users
• 1.9 Purging the Developer Activity and Click Count Log Files
  • 1.9.1 Purging the Developer Activity Log
  • 1.9.2 Purging the External Click Count Log
• 1.10 Managing Session State and User Preferences
  • 1.10.1 Managing Session State
  • 1.10.2 Managing User Preferences
• 1.11 Managing Page and Region Caching
  • 1.11.1 Purging Cached Regions
  • 1.11.2 Purging Cached Pages
• 1.12 Changing Build Status for Multiple Applications
• 1.13 Managing Application Models
  • 1.13.1 Deleting an Application Model
• 1.14 Monitoring Activity Within a Workspace
  • 1.14.1 Viewing Developer Activity and Application Change Information
  • 1.14.2 Viewing Application Changes by Developer
  • 1.14.3 Viewing Application Changes by Day
  • 1.14.4 Viewing Active Sessions
  • 1.14.5 Viewing Schema Reports
• 1.15 Viewing Workspace Dashboards
  • 1.15.1 About the Workspace Dashboard
  • 1.15.2 About the Users Dashboard
  • 1.15.3 About the Activity Dashboard
  • 1.15.4 About the Developer Activity Dashboard
  • 1.15.5 About the Performance Dashboard
  • 1.15.6 About the Websheets Dashboard
  • 1.15.7 About the Applications Dashboard
  • 1.15.8 About the Database Dashboard
• 1.16 Leveraging Application Builder Defaults
  • 1.16.1 About Application Builder Defaults
  • 1.16.2 Configuring Application Builder Defaults

2 Oracle Application Express Hosted Instance Administration

• 2.1 What Is an Instance Administrator?
  • 2.1.1 About the Instance Administration Home Page
  • 2.1.2 About the Manage Instance Page
  • 2.1.3 About the Manage Workspaces Page
• 2.2 Logging In To Oracle Application Express Administration Services
• 2.3 Managing Workspace and Change Requests
  • 2.3.1 Viewing Requests on the Instance Administration Home Page
  • 2.3.2 Viewing Pending Requests
  • 2.3.3 Managing Workspace Requests
  • 2.3.4 Managing Change Requests
• 2.4 Managing Instance Settings
  • 2.4.1 Managing Feature Configuration
  • 2.4.2 Configuring Security Settings
  • 2.4.3 Configuring Instance Settings
  • 2.4.4 Including an Agreement or Survey When Running the Signup Wizard
  • 2.4.5 Purging Inactive Workspaces
  • 2.4.6 Viewing Information About Installed Packaged Database Applications
  • 2.4.7 Monitoring the Progress Packaged Application Installations
  • 2.4.8 Managing Public Themes
  • 2.4.9 Managing Template Applications
  • 2.4.10 Managing Session State
  • 2.4.11 Managing the Mail Queue
  • 2.4.12 Viewing Installed Translations
  • 2.4.13 Managing Interactive Report Subscriptions
  • 2.4.14 Managing Logs and Files
  • 2.4.15 Managing a Runtime Environment
  • 2.4.16 Managing Messages
  • 2.4.17 About the Self Service Sign Up Wizard
• 2.5 Managing Schemas
  • 2.5.1 Determining the Oracle Application Express Engine Schema
  • 2.5.2 Understanding Oracle Default Schema Restrictions
• 2.6 Creating Workspaces
  • 2.6.1 About Workspace Provisioning
  • 2.6.2 Specifying a Provisioning Mode
  • 2.6.3 Creating a Workspace Manually
  • 2.6.4 Creating Multiple Workspaces
• 2.7 Managing Existing Workspaces
  • 2.7.1 Deleting a Workspace
  • 2.7.2 Locking a Workspace
  • 2.7.3 Managing Workspace to Schema Assignments
  • 2.7.4 Managing Component Availability
  • 2.7.5 Performing a Workspace Search
  • 2.7.6 Viewing Existing Workspaces
  • 2.7.7 Editing Workspace Details
  • 2.7.8 Viewing Workspace Details
  • 2.7.9 Viewing Workspace Database Privileges
  • 2.7.10 Viewing File Size and File Count by Workspace
  • 2.7.11 Exporting and Importing a Workspace
  • 2.7.12 Viewing Application Attributes
  • 2.7.13 Changing Application Build Status Set During Deployment
  • 2.7.14 Viewing the Parsing Schemas Report
• 2.8 Managing Users in an Oracle Application Express Instance
  • 2.8.1 Creating New User Accounts
  • 2.8.2 Editing an Existing User Account
  • 2.8.3 Deleting User Accounts
• 2.9 Monitoring Activity Across a Development Instance
  • 2.9.1 Monitoring Activity
  • 2.9.2 Viewing the Signup Survey Report

A About DBMS_SCHEDULER Jobs

• A.1 DBMS_SCHEDULER Jobs In Oracle Application Express

Index