32/43
2.7 Managing Meta Data
Use the links under Manage Meta Data to view and manage session state, the mail queue, installed translations, and interactive report descriptions.
2.7.1 Managing Session State for an Instance
View session state statistics and purge the session state on the Session State page.
2.7.1.1 About Session State
A 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.
2.7.1.2 Viewing Session Details Before Purging
Before 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.
- 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:
2.7.1.3 Purging Sessions by Age
Purge sessions by age on the Purge Session page.
To purge sessions by age:
- Sign in to 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.
2.7.1.4 Viewing Session Statistics Before Purging
View statistics about current sessions before purging on the Session State Statistics page.
To view session state statistics:
- Sign in to 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.
2.7.2 Managing the Mail Queue
Manage email sent from applications by monitoring email messages in the mail queue.
2.7.2.1 Sending and Deleting Messages in the Mail Queue
Use the Mail Queue to push, delete, or reset messages in the mail queue.
To send and delete messages in the mail queue:
- Sign in to 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:
- Delete - Deletes selected messages.
- 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.
- Send All Mail - Pushes the messages in the queue. The calculated delay for messages which encounter an error is observed.
- Reset - Resets the page pagination.
2.7.3 Viewing Installed Translations
Access the Installed Translations page to view 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.
- 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.
2.7.4 Deleting Interactive Report Subscriptions
Manage the interactive report subscriptions within the current development instance.
To delete an interactive report subscription:
- Sign in to 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.