Note:
Functionality in the Administration Services application is not available in Oracle Database Cloud Service (Database Schema).Instance administrators use the links under Manage Meta Data to view and manage session state, the mail queue, installed translations, and interactive report descriptions.
This section describes how to view session state statistics and purge the session state on the Session State page.
See Also:
"Managing Session State for a Workspace" and "Managing Session State" in Oracle Application Express Application Builder User's GuideA session is a logical construct used to establish persistence (or stateful behavior) across page views. Each session is assigned a unique ID, which the Application Express engine uses to store and retrieve an application's working set of data (or session state) before and after each page view. An automatic process clears sessions older than 24 hours every eight hours. Instance administrators can also purge them manually.
See Also:
"What Is a Session?" in Oracle Application Express Application Builder User's GuideBefore purging sessions, Instance administrators can view a listing of recent sessions and then drill down on session details on the Recent Sessions page.
To view a listing of recent sessions:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Instance.
Under Manage Meta Data, click Session State.
The Session State page appears.
Click Recent Sessions.
On the Recent Sessions page, you can:
Click a session number to view additional details.
Click Purge Sessions to delete the displayed sessions.
Using the Purge Session page, Instance administrators can purge sessions by age.
To purge sessions by age:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Instance.
Under Manage Meta Data, click Session State.
The Session State page appears.
Click Purge Sessions.
The Purge Sessions page appears.
For Maximum Sessions to Purge, identify the maximum number of sessions to delete.
For Only Purge Session Older Than, specify the age of sessions to be deleted.
To purge the selected sessions, click Purge Sessions.
On the Session State Statistics page, Instance administrators can view statistics about current sessions before purging.
To view session state statistics:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Instance.
Under Manage Meta Data, click Session State.
The Session State page appears.
Select Session State Statistics.
To delete current sessions, click Purge Sessions.
This section describes how Instance administrators can manage email sent from applications by monitoring email messages in the mail queue.
Tip:
To view the Mail Log, see "Monitoring Activity Across a Development Instance"To send and delete messages in the mail queue:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Instance.
Under Manage Meta Data, click Mail Queue.
The Mail Queue page appears.
If there is an issue sending an email (for example, because of a bad email address or unavailable mail server) then the mail message remains in the queue along with the last encountered error. For every subsequent attempt to send the email, the gap in time increases between send attempts (for example, 1 minute, 2 minutes, 4 minutes, 8 minutes, 16 minutes, and so on).
Use the following buttons to manage messages in the mail queue:
Send All Mail - Pushes the messages in the queue. The calculated delay for messages which encounter an error is observed.
Force Send All Mail - The calculated delay for messages which encounter an error is ignored and an attempt is made to push all messages in the queue.
Delete - Deletes selected messages.
Reset - Resets the page pagination.
See Also:
"Configuring Email" and "Sending Email from an Application" in Oracle Application Express Application Builder User's GuideInstance administrators can view a page showing which translated languages have been installed within the current development instance.
To view the list of installed translations:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Instance.
Under Manage Meta Data, click Installed Translations.
The Installed Translations page appears. This page displays a list of languages and indicates if the translations have been loaded.
See Also:
"Managing Application Globalization" in Oracle Application Express Application Builder User's GuideInstance administrators can manage the interactive report subscriptions within the current development instance.
To delete an interactive report subscription:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Instance.
Under Manage Meta Data, click Interactive Report Subscriptions.
The Interactive Report Subscriptions page displays as an interactive report. You can customize the appearance of the page using the Search bar at the top of the page.
Find the subscription you want to remove and select the check box to the left.
Click Delete Checked.
See Also:
"Subscribing to Interactive Reports" in Oracle Application Express Application Builder User's Guide and "REMOVE_SUBSCRIPTION Procedure" in Oracle Application Express API Reference