Bad Performance At Login - AWR Report Points to WC_NAVIGATION_ACTIVITY table
(Doc ID 1586752.1)
Last updated on OCTOBER 01, 2022
Oracle WebCenter Portal - Version 184.108.40.206.5 to 220.127.116.11.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.