Previous Next JavaScript must be enabled to correctly display this content

## 3.6 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.

- Managing Session State for an Instance
  View session state statistics and purge the session state on the Session State page.
- Managing the Mail Queue
  Manage email sent from applications by monitoring email messages in the mail queue.
- Managing the Push Notifications Queue
  Manage push notifications sent from applications in the Push Notifications Queue.
- Viewing Installed Translations
  Access the Installed Translations page to view which translated languages have been installed in this Oracle APEX instance.
- Deleting Interactive Report Subscriptions
  Manage the interactive report subscriptions within the current development instance.

Parent topic: Oracle APEX Administration Services

### 3.6.1 Managing Session State for an Instance

View session state statistics and purge the session state on the Session State page.

- About Session State
  A session is a logical construct used to establish persistence (or stateful behavior) across page views.
- 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.
- Purging Sessions by Age
  Purge sessions by age on the Purge Session page.
- Viewing Session Statistics Before Purging
  View statistics about current sessions before purging on the Session State Statistics page.

See Also:

Managing Session State for a Workspace and Managing Session State Values in Oracle APEX App Builder User’s Guide

Parent topic: Managing Meta Data

#### 3.6.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 Oracle APEX 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 APEX App Builder User’s Guide

Parent topic: Managing Session State for an Instance

#### 3.6.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:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. Under Manage Meta Data, click Session State.

   The Session State page appears.

4. Click Recent Sessions.
5. On the Recent Sessions page, you can:
   - Click a session number to view additional details.
   - Click Purge Sessions to delete the displayed sessions.

Parent topic: Managing Session State for an Instance

#### 3.6.1.3 Purging Sessions by Age

Purge sessions by age on the Purge Session page.

To purge sessions by age:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. Under Manage Meta Data, click Session State.

   The Session State page appears.

4. Click Purge Sessions.

   The Purge Sessions page appears.

5. For Maximum Sessions to Purge, identify the maximum number of sessions to delete.
6. For Only Purge Session Older Than, specify the age of sessions to be deleted.
7. To purge the selected sessions, click Purge Sessions.

Parent topic: Managing Session State for an Instance

#### 3.6.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:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. Under Manage Meta Data, click Session State.

   The Session State page appears.

4. Select Session State Statistics.
5. To delete current sessions, click Purge Sessions.

Parent topic: Managing Session State for an Instance

### 3.6.2 Managing the Mail Queue

Manage email sent from applications by monitoring email messages in the mail queue.

Tip:

To view the Mail Log, see Monitoring Activity Across an Instance

- Sending and Deleting Messages in the Mail Queue
  Use the Mail Queue to push, delete, or reset messages in the mail queue.

Parent topic: Managing Meta Data

#### 3.6.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:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. 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. The Oracle APEX instance will automatically attempt to resend this mail message up to 14 times. For every subsequent attempt to send the email, the gap in time between send attempts exponentially increases (2 minutes, 4 minutes, 8 minutes, 16 minutes, and so on). If the delivery remains unsuccessful, the mail message is removed from the queue and the latest error is captured in the `apex_mail_log` dictionary view.

4. 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.

See Also:

- Configuring Email
- Sending Email from an Application in Oracle APEX App Builder User’s Guide

Parent topic: Managing the Mail Queue

### 3.6.3 Managing the Push Notifications Queue

Manage push notifications sent from applications in the Push Notifications Queue.

- Monitoring the Push Notifications Queue
  Monitor the Push Notifications Queue by sending notifications or deleting notifications in the queue.

See Also:

Creating a Progressive Web App (PWA) in Oracle APEX App Builder User’s Guide

Parent topic: Managing Meta Data

#### 3.6.3.1 Monitoring the Push Notifications Queue

Monitor the Push Notifications Queue by sending notifications or deleting notifications in the queue.

To monitor the Push Notifications Queue:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. Under Manage Meta Data, click Push Notifications Queue.

   The Push Notifications Queue page appears.

4. Use the following buttons to manage push notifications in the queue:
   - Force Push Queue - The calculated delay for notifications which encounter an error is ignored and an attempt is made to push all notifications in the queue
   - Push Queue - Pushes all notifications in the queue. The calculated delay for notifications which encounter an error is observed.
5. To delete a notification:
   - Click the Row Actions menu and select Delete Row.

Parent topic: Managing the Push Notifications Queue

### 3.6.4 Viewing Installed Translations

Access the Installed Translations page to view which translated languages have been installed in this Oracle APEX instance.

To view the list of installed translations:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. 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:

- Installing Translated Versions of APEX in Oracle APEX Installation Guide
- Managing Application Globalization in Oracle APEX App Builder User’s Guide

Parent topic: Managing Meta Data

### 3.6.5 Deleting Interactive Report Subscriptions

Manage the interactive report subscriptions within the current development instance.

To delete an interactive report subscription:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. 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.

4. Find the subscription you want to remove and select the check box to the left.
5. Click Delete Checked.

See Also:

- Subscribing to Report Updates by Email in Oracle APEX End User’s Guide

- REMOVE_SUBSCRIPTION Procedure in Oracle APEX API Reference

Parent topic: Managing Meta Data