2.10 Managing Session State for a Workspace

A session establishes persistence (or stateful behavior) across page views. Workspace administrators can view session details for the current session or for recent sessions, purge the current session state, or purge sessions based on their age.

• About Session State
  A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique ID, which the APEX engine uses to store and retrieve an application's working set of data (or session state) before and after each page view. Sessions persist in the database until purged.
• Removing Session State After Reviewing Session Details
  Determine whether to remove existing sessions by first reviewing session details. From the Session Details page, administrators can remove the session record or session state.
• Viewing Session State for the Current Session
  View sessions state for the current session on the Session State page.
• Purging Sessions by Age
  Purge existing sessions by age on the Purge Sessions page.
• Purging Session State for the Current Session
  Purge session state for the current session on the Purge Session State page.

See Also:

• Managing Session State for an Instance
• Understanding Session State Management in Oracle APEX App Builder User’s Guide

2.10.1 About Session State

A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique ID, which the APEX engine uses to store and retrieve an application's working set of data (or session state) before and after each page view. Sessions persist in the database until purged.

See Also:

What is Session State? in Oracle APEX App Builder User’s Guide

2.10.2 Removing Session State After Reviewing Session Details

Determine whether to remove existing sessions by first reviewing session details. From the Session Details page, administrators can remove the session record or session state.

To view session details and remove session state:

1. Navigate to the Workspace Administration page:
   1. Sign in to APEX.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Administration page, click Manage Service.
3. Under Manage Meta Data, click Session State.
4. Click Recent Sessions.

   You can customize the appearance of the page using the Search bar at the top of the page

5. To view session details, select the session ID.
6. On the Sessions Details page, click one of the following buttons:
   • Remove State clears the session data from the session state tables (including collections data) but does not remove the session record. Removing a session is a good approach for developers during debugging. This is the equivalent of clearing session state for the current session using the Clear Cache argument value SESSION in the f?p URL. This option might also be used by developers during debugging.
   • Remove Session removes the record of the session from the SESSIONS table along with the session state (including collections data) associated with the session. Any user using a session that has removed is no longer able to use the session and is prompted to re-authenticate upon their next page request (in most situations). This option can be used by administrators to ensure a specific user can no longer access an Oracle APEX application.

See Also:

Debugging an Application in Oracle APEX App Builder User’s Guide

2.10.3 Viewing Session State for the Current Session

View sessions state for the current session on the Session State page.

To view session state for the current or recent sessions:

1. Navigate to the Workspace Administration page:
   1. Sign in to APEX.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Administration page, click Manage Service.
3. Under Manage Meta Data, click Session State.
4. Click Session State for Current Session.

   You can customize the appearance of the page using the Search bar at the top of the page

See Also:

Removing Session State After Reviewing Session Details

2.10.4 Purging Sessions by Age

Purge existing sessions by age on the Purge Sessions page.

To purge existing sessions by age:

1. Navigate to the Workspace Administration page:
   1. Sign in to APEX.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Administration page, click Manage Service.
3. Under Manage Meta Data, click Session State.
4. Click Purge Sessions by Age.
5. On Purge Sessions, make a selection from the Sessions older than list.
6. Click one of the following buttons:
   • Report Sessions generates a report detailing the total number of sessions for the workspace, the number of users, and the number of old sessions.
   • Purge Sessions purges existing sessions by the age you selected.

See Also:

Viewing Session State in Oracle APEX App Builder User’s Guide

2.10.5 Purging Session State for the Current Session

Purge session state for the current session on the Purge Session State page.

To purge session state for the current session:

1. Navigate to the Workspace Administration page:
   1. Sign in to APEX.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Administration page, click Manage Service.
3. Under Manage Meta Data, click Session State.
4. Click Purge Session State for Current Session.
5. Click one of the following buttons:
   • View Session State - Displays information about the current session.
   • Purge Session State - Resets the session state for the current session.