Inserting a Record into a Table S_AUDIT_ITEM Without Bind Variables
(Doc ID 2384976.1)
Last updated on FEBRUARY 07, 2019
Applies to:Siebel CRM - Version 220.127.116.11 [IP2014] to 18.9 [Release V8 to V17]
Information in this document applies to any platform.
It was reported that when merging / deleting contacts application is inserting a record into a table S_AUDIT_ITEM without bind variables
The behavior was reproduced in the latest versions of the applications 16.18 and 17.4
Insert statements in S_AUDIT_ITEM table should use bind variables, the query without bind variables affects database shared_pool memory usage and performance.
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