2.5.4 Purging Inactive Workspaces

Inactive workspaces consume valuable storage space and degrade system performance. Instance administrator can configure an instance to periodically purge inactive workspaces.

By enabling Workspace Purge Settings, you can configure Oracle Application Express to purge inactive workspaces. If a workspace is designated as inactive, Oracle Application Express sends notification email to each workspace administrator explaining that the workspace will be purged in a specific number of days. The workspace administrator can prevent the workspace from being purged by following an embedded link and following the online instructions.

• Configuring Workspace Purge Settings
  Configure workspace purge settings on the Workspace Purge Settings page.

See Also:

"Monitoring Activity Across a Development Instance" to view reports concerning purging workspaces and "Sending Email from an Application" in Oracle Application Express App Builder User’s Guide

2.5.4.1 Configuring Workspace Purge Settings

Configure workspace purge settings on the Workspace Purge Settings page.

If a workspace is designated as inactive, Oracle Application Expres sends a notification email to each workspace administrator explaining that the workspace will be purged in a specific number of days. In order for this email notification to work, you must configure email for your instance. See "Configuring Email."

To configure workspace purge settings:

1. Sign in to Oracle Application Express Administration Services.
2. Click Manage Instance.
3. Under Instance Settings, click Workspace Purge Settings.
4. On the Workspace Purge Settings, configure the following:
   1. Enabled - Select Yes to enable the workspace purge process. Select No to disable the workspace purge process.
   2. Language - Select the language of the text of emails sent to workspace administrators of inactive workspaces. Note that only one language can be selected for each instance.
   3. Purge Administration Email Address - Enter the email address (or From address) from which emails are sent to workspace administrators.
   4. Send Summary Email To - Enter a list of email addresses separated by commas. Recipients will receive a daily email summary of the purge process.
   5. Days Until Purge - Enter the number of days before a workspace is physically purged. For example, entering 10 means a workspace will be purged 10 days after it is added to the inactive list.
   6. Reminder Days in Advance - Enter the number of days before the purge date to send a reminder email to workspace administrators. Reminder email criteria includes:

      • The workspace is on the inactive list.

      • There has been no activity in the workspace.

      • The workspace administrator has not chosen to follow the link in the email to prevent the workspace from being purged.

   7. Days Inactive - Enter the number of days of inactivity before a workspace is classified as inactive. Inactivity includes not logging into the workspace and the no runtime activity of any application in the workspace.
   8. Grace Period (Days) - Enter the number of days for the grace period. The grace period starts after workspace administrators click the link in the email to not have their workspace purged. If there is no activity during the grace period, the workspace is added back to the list of inactive workspaces.
   9. Maximum Execution Time (Hours) - Enter the number limiting the number of hours that the purge process may execute per run of the workspace purge job
   10. Maximum Number of Workspaces - Enter the maximum number of workspaces to be purged per run of the workspace purge job.
   11. Maximum Number of Emails - Enter the maximum number of reminder emails and workspace inactive emails to be send per run of the workspace purge job.
5. Click Apply Changes.