How Wwctx_sso.Cleanup_sessions Job Works Within Oracle Portal

(Doc ID 1269597.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Portal - Version and later
Information in this document applies to any platform.
Checked for relevance on 20-Feb-2015


Sometime the application server locks up when the cleanup session job is running at the same time as users use the system. Also the shared database environment is getting a lot of CPU load when the 'wwctx_sso.cleanup_sessions' job defined on dba_jobs table,  is running at daytime.
If the content of the related PORTAL.WWCTX_SSO_SESSION$ table is deleted usually every 30 min (that was at least how it was configured earlier) why is this information stored in a table?


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