My Oracle Support Banner

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 8.1.1.14 [IP2014] and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR  
---------------

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

e.g.

 


EXPECTED BEHAVIOR
-----------------------


Insert statements in S_AUDIT_ITEM table should use bind variables, the query without bind variables  affects database shared_pool memory usage and performance.




Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.