Long Running Query Against SIEBEL.S_AUDIT_ITEM
(Doc ID 781941.1)
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 220.127.116.11 SIA  to 18.104.22.168 SIA  [Release V7]
Information in this document applies to any platform.
Checked for Relevance on 08-Jul-2014
””Checked for Relevance on 21-DEC-2015””
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:
T2.USER_ID = T1.PAR_ROW_ID (+)
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.
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|