Managing Session State

A session is a logical construct that is 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. Oracle Application Express administrators can also purge them manually.

An Oracle Application Express administrator can view session state statistics and purge the session state on the Session State page.

Topics:


See Also:

"Managing Session State" in Oracle Application Express Application Builder User's Guide

Purging Sessions by Age

Using the Purge Session page, Oracle Application Express administrators can purge sessions by age.

To view specific session details:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Session State.

  4. Click Purge Sessions, by age.

  5. On the Purge Sessions page, specify:

    • The maximum number of sessions to be purged

    • The age of sessions to be purged

  6. To view a report of session statistics, click Count Sessions.

  7. To purge the selected sessions, click Purge Sessions.

Viewing Session Details Before Purging

Before purging sessions, Oracle Application Express administrators can use the Recent Sessions page to first view a listing of recent sessions and then drill down on session details.

To purge sessions by age:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Session State.

  4. Click Recent Sessions, with drill down to session details.

  5. On the Recent Sessions page, you can:

    • Click a session number to view additional details.

    • Click Purge Sessions to delete the displayed sessions.

Viewing Session Statistics Before Purging

On the Session State Statistics page, Oracle Application Express administrators can view statistics about current sessions prior to purging.

To view session state statistics:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Session State.

  4. Select Session State Statistics.

  5. Click Purge Sessions to delete the current sessions.