Managing Session State

Viewing and Purging Session State for the Current Session

To view session state for the current session:

1. On the Database Home Page, click the Application Builder icon.

2. From the Administration list, select Manage Services.

3. Click Session State.

4. When the Session State page appears, click Current preferences and session state with an option to purge.

5. To view information about the current session, click View Session State.

6. To reset the session state for the current session, click Purge Session State.

Purging Sessions by Age

To purge existing session by age:

1. On the Database Home Page, click the Application Builder icon.

2. From the Administration list, select Manage Services.

3. Click Session State.

4. Select Purge sessions by age.

5. Make a selection from Sessions older than.

6. Click one of the following buttons:

   • Report Session generates a report detailing the total number of sessions for the database user account, the number of users, and the number of old sessions.

   • Purge Sessions purges existing sessions by age.

Viewing Session Details Prior to Removing Session State

You can determine whether to remove existing sessions by first reviewing session details on the Session State page.

To view session details prior to removing session state:

1. On the Database Home Page, click the Application Builder icon.

2. From the Administration list, select Manage Services.

3. Click Session State.

4. Select Recent sessions with drill down to session details.

5. To narrow the results, select a time increment, specify a user, and click Go.

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

   The Session Details page appears.

7. Click one of the following buttons:

   • Remove Session. Removes the record of the session from the SESSIONS table along with 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 in most situations upon their next page request. This option could be used by administrators who might have a need to make sure a certain a specific user could no longer access to an Oracle Application Express applications.

   • 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 be used by developers during debugging.