Bad Performance At Login - AWR Report Points to WC_NAVIGATION_ACTIVITY table
Last updated on MAY 02, 2018
Applies to: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.
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