My Oracle Support Banner

Bad Performance at Login - AWR Report Points to WC_NAVIGATION_ACTIVITY Table (Doc ID 1586752.1)

Last updated on MAY 22, 2024

Applies to:

Oracle WebCenter Portal - Version to [Release 11g]
Information in this document applies to any platform.


Archive logs growing exponentially and certain users have bad performance on login to 11.1.1.x WebCenter installation.
Analysis of AWR shows that WC_NAVIGATION_ACTIVITY table is key.

Analysis of table shows that there are a significant number of rows for certain users, and the data in then shows duplicate values except for ID.

WC_ACTIVITY_PAGE_ACCESS_UN is a unique index based on user_id,page_url and has been disabled as recommended by Oracle previously.




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
Solution / .x

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