Managing Session State

Removing Session State After Reviewing Session Details

You can determine whether to remove existing sessions by first reviewing session details. From the Session Details page, you can then remove the session record or session state.

To view session details and remove session state:

1. Log in to Oracle Application Express. See "Logging In to Oracle Application Express" in Oracle Application Express Application Builder User's Guide.

   The Workspace home page appears.

2. Click the Administration icon.

3. On the Administration page, click Manage Service.

4. Under Manage Meta Data, click Session State.

5. Click Recent Sessions with Drill-Down to Session Details.

6. You can customize the appearance the page using the Search bar at the top of the page. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.

7. To view session details, select the session ID.

   The Session Details page appears.

8. 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 is removed will no longer be able to use the session and will be prompted to re-authenticate upon their next page request (in most situations). This option can be used by administrators who need to ensure a specific user can no longer access an Oracle Application Express application.

Viewing Session State for the Current Session

To view session state for the current or recent sessions:

1. Log in to Oracle Application Express. See "Logging In to Oracle Application Express" in Oracle Application Express Application Builder User's Guide.

   The Workspace home page appears.

2. Click the Administration icon.

3. On the Administration page, click Manage Service.

4. Under Manage Meta Data, click Session State.

5. Click Report Session State for Current Session.

6. You can customize the appearance the page using the Search bar at the top of the page. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.

Purging Sessions by Age

To purge existing sessions by age:

1. Log in to Oracle Application Express. See "Logging In to Oracle Application Express" in Oracle Application Express Application Builder User's Guide.

   The Workspace home page appears.

2. Click the Administration icon.

3. On the Administration page, click Manage Service.

4. Under Manage Meta Data, click Session State.

5. Click Purge sessions by Age.

6. Make a selection from the Sessions older than list.

7. Click one of the following buttons:

   • Purge Sessions purges existing sessions by the age you selected.

   • Report Sessions generates a report detailing the total number of sessions for the workspace, the number of users, and the number of old sessions.

Purging Session State for the Current Session

To purge session state for the current session:

1. Log in to Oracle Application Express. See "Logging In to Oracle Application Express" in Oracle Application Express Application Builder User's Guide.

   The Workspace home page appears.

2. Click the Administration icon.

3. On the Administration page, click Manage Service.

4. Under Manage Meta Data, click Session State.

5. Click Purge Session State for Current Session.

6. 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.