Having performance issues with the Portal WWCTX_SSO_SESSION$ table ? (Doc ID 566224.1)

Last updated on MARCH 08, 2017

Applies to:

Portal - Version 9.0.4.1 to 10.1.4.2 [Release 10g to 10gR2]
Information in this document applies to any platform.
Checked for relevance on 12-Mar-2015

Symptoms

Oracle Portal makes extensive use of the table WWCTX_SSO_SESSION$ table.  All accesses to the Portal site, including PUBLIC access, produce a row in this table not just login events and subsequent return visits will require regular reading of this table.  In addition, other internal events will use this table for temporary data storage.  Any problem or issue of maintenance of this table will have a site-wide effect on performance.  A healthy is a happy Portal.

This note describes the role of this table and how to manage and maintain it to optimise the performance of Portal.  It also contains some useful SQL statements for 10.x Database to help prove that there is an issue with the access to the WWCTX_SSO_SESSION$ table.

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