Long Running Query Against SIEBEL.S_AUDIT_ITEM
(Doc ID 781941.1)
Last updated on APRIL 04, 2025
Applies to:
Siebel Tools - Version 7.8.2.9 SIA [19238] to 7.8.2.16 SIA [19255] [Release V7]Information in this document applies to any platform.
Symptoms
A long-running query occurs when Audit Trail Engine is enabled and these steps are performed:
- Navigate to Account Quote View
- Create a quote
- Drill down on the quote which opens the Quote Screen
- Click the thread link to return to Account Quote View.
This results in the following long running query:
Note that there is no search specification in the WHERE clause, only a join. This causes the query to take a long time to execute, especially when the tables are large.
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 |
| Cause |
| Solution |