Agile Login Performance Is Slow : Multiple Update Statements Against USER_USAGE_HISTORY Table
(Doc ID 2622705.1)
Last updated on DECEMBER 26, 2019
Applies to:Oracle Agile Product Collaboration - Version 18.104.22.168 and later
Information in this document applies to any platform.
Agile Web Client login is very slow and performance is impacted.
After taking the AWR report, found below SQL are impacting performance for both Elapsed Time and CPU Time.
1. Issue is happening on clustered instance
1. Start Agile Application Server
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