High Disk Read From USER_USAGE_HISTORY in Agile 9.3.1.2
(Doc ID 1936473.1)
Last updated on APRIL 17, 2025
Applies to:
Oracle Agile PLM Framework - Version 9.3.1.2 and laterInformation in this document applies to any platform.
Symptoms
Following SQL statement use many disk I/O:
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 not in (SELE CT sid FROM user_session)
The issue can be reproduced at will with the following steps:
1. Run AWR report
2. Check the SQL with high I/O
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 |