Inserting a Record into a Table S_AUDIT_ITEM Without Bind Variables
(Doc ID 2384976.1)
Last updated on APRIL 27, 2018
Applies to:Siebel CRM - Version 184.108.40.206 [IP2014] and later
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!