My Oracle Support Banner

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

Last updated on NOVEMBER 02, 2018

Applies to:

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


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.


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.