1.9 Managing Session State for a Workspace

A session is a logical construct that establishes 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. Sessions persist in the database until purged.

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.

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   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 who must ensure a specific user can no longer access an Oracle Application Express application.

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

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   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

Purge existing sessions by age on the Purge Sessions page.

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   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.

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

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   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.