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.

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

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

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.

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.

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.

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

Mail Queue Overview

The Mail Queue Overview is a live queue health report for APEX email delivery. For each queued email, it shows the recipient, sender, subject, cc/bcc, creation time, queue age in minutes, last update details, send error, send attempt count, next retry time, and workspace name.

The Mail Queue Overview includes saved report views that address common troubleshooting scenarios, including: - Emails for which sending has been attempted but that remain in the queue awaiting delivery - Emails awaiting delivery, grouped by workspace - Emails taking more than 5 minutes, grouped by workspace - Emails with delivery errors

To monitor the mail queue:

  1. Sign in to Administration Services.
  2. Select Manage Instance.
  3. Under Manage Meta Data, select Mail Queue.

The Mail Queue page appears.

Sending and Deleting Messages in the Mail Queue

Use the Mail Queue to push, delete, or reset messages in the mail queue.

If there is an issue sending an email (for example, because of an unresolvable email address or an unavailable mail server), then the mail message remains in the queue along with the last encountered error. The Oracle APEX instance automatically attempts 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.

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.

  4. Use the following buttons to manage messages in the mail queue:

    1. Delete - Deletes selected messages.
    2. Force Send All Mail - APEX pushes all messages in the queue, ignoring the calculated delay for messages that encounter an error.
    3. Send All Mail - APEX pushes the messages in the queue. APEX observes the calculated delay for messages that encounter an error.

Related Resources

For more information, see:

About the Mail Queue Metrics Dashboard

The Mail Queue Metrics Dashboard is an operational snapshot of email-delivery health. It displays four key counts:

  1. Emails delivered within the last 10 minutes
  2. Emails currently awaiting delivery
  3. Emails in the retry queue due to delivery errors
  4. Emails waiting for more than 5 minutes

Together, these metrics help administrators quickly identify whether mail is flowing normally, accumulating in the queue, retrying due to errors, or becoming delayed.

About the Operational and Triage Section

The Operational and Triage section is the administrator’s workspace for monitoring and diagnosing outbound email delivery. It helps identify messages taking longer than 5 minutes to be sent, grouped by workspace and checking whether the delivery limit was reached on a rolling 24-hour period.

About the Trending Section

This section displays the Top 10 workspace charts that highlight recent high-volume email activity.

About the Monitoring Section

The Emails Sent Summary presents a broader view of email activity for the selected period. It compares created, queued, sent, and failed messages with the previous equivalent period and displays changes as counts or percentages. The accompanying chart shows daily sending trends.

Using these charts, you can confirm which emails were successfully sent and identify messages that took longer than expected to deliver.

Managing the Push Notifications Queue

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

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

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.

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:

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: