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. Instance administrators can also purge them manually.

An Instance administrator can view session state statistics and purge the session state on the Session State page.

Topics:

Viewing Session Details Before Purging
Purging Sessions by Age
Viewing Session Statistics Before Purging

Viewing Session Details Before Purging

Before purging sessions, Instance 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:

Log in to Oracle Application Express Administration Services. See "Logging 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, with drill down to session details.
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

Using the Purge Session page, Instance administrators can purge sessions by age.

To view specific session details:

Log in to Oracle Application Express Administration Services. See "Logging 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, by age.
On the Purge Sessions page, specify:
- The maximum number of sessions to be purged
- The age of sessions to be purged
To view a report of session statistics, click Count Sessions.
To purge the selected sessions, click Purge Sessions.

Viewing Session Statistics Before Purging

On the Session State Statistics page, Instance administrators can view statistics about current sessions before purging.

To view session state statistics:

Log in to Oracle Application Express Administration Services. See "Logging 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.
Click Purge Sessions to delete the current sessions.