Long Running Query Against SIEBEL.S_AUDIT_ITEM
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms