Active Portal Sessions Are Terminated By The Cleanup Job After Changing The Job With ctxjsub.sql (Doc ID 473673.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Portal - Version 9.0.4 and later
Information in this document applies to any platform.
Checked for relevance on 08-Dec-2014


Symptoms

A website, characterized with a large number of logins, faced an increase in the number of sessions created in the session table PORTAL.WWCTX_SSO_SESSION$. A large number of sessions were created by users who had already closed their browser. These users did not use the logout functionality in Oracle Portal to terminate their session.

The session cleanup job was reconfigured to run twice every hour instead of once a day to ensure that the sessions from these users were removed from the session tables. After modification of the session cleanup job, all user sessions were terminated after 30 minutes, regardless whether the user was active or not.

Changes

The session cleanup job ctxjsub.sql was reconfigured with the following parameters :

Example :

SQL> @ctxjsub 0.5 2008-01-08:11:00:00 YYYY-MM-DD:HH24:MI:SS 0.5

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms