My Oracle Support Banner

Agile Login Performance Is Slow : Multiple Update Statements Against USER_USAGE_HISTORY Table (Doc ID 2622705.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
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.

UPDATE user_usage_history SET logout_time=:1 WHERE NVL(LOGOUT_TIME, TO_DATE('01/01/1970 12:00:00', 'mm/dd/yyyy hh:mi:ss')) < TO_DATE('01/01/1971 12:00:00', 'mm/dd/yyyy hh:mi:ss') and (sid in (SELECT sid FROM user_session WHERE timeout > 0 and last_refresh+(timeout/(60*24)) < :2 ) OR (substr(sid, 1, INSTR(sid, '--:LDAP:--', 1, 1) - 1) in (SELECT sid FROM user_session WHERE timeout > 0 and last_refresh+(timeout/(60*24)) < :3 )))


FACT
1. Issue is happening on clustered instance

STEPS
1. Start Agile Application Server

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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