Active Portal Sessions Are Terminated By The Cleanup Job After Changing The Job With ctxjsub.sql
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
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 :
- p_hours_old was changed to 0.5
- interval_hours was changed to 0.5
SQL> @ctxjsub 0.5 2008-01-08:11:00:00 YYYY-MM-DD:HH24:MI:SS 0.5
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