PERFORMANCE PROBLEM OPENING AN SR - QUERY FOR ATTACHMENTS ISSUES FULL TABLE SCAN
(Doc ID 741045.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle iSupport - Version 12.0.4 to 12.0.6 [Release 12]Information in this document applies to any platform.
Symptoms
Find that opening a service request in iSupport takes more than 40 seconds, in case fnd_attached_documents table contains many records.
EXPECTED BEHAVIOR
Expect to be able to open a service request in few seconds.
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Login as an iSupport business user
2. Open an existing service request
3. It will take about 40 minutes
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 |