Bad Performance At Login - AWR Report Points to WC_NAVIGATION_ACTIVITY table
(Doc ID 1586752.1)
Last updated on FEBRUARY 11, 2019
Oracle WebCenter Portal - Version 18.104.22.168.5 to 22.214.171.124.5 [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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.