Oracle Waveset Not Using Bind Variables Resulting In High Sharedpool Utilization (Doc ID 1949305.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Waveset - Version 8.1.1.1 and later
Information in this document applies to any platform.

Goal

Waveset is not using Bind variables which results in high sharedpool utilization

Current: SELECT account.id, name, xml, lockinfo, '', modified, counter, '', repoMod from account WHERE ( id='#ID#9A74:6B995ECC341:D0F815F4-:01AAFCEC255A04F3' )

Expected:
At application level , assign b1='#ID#9A74:6B995ECC341:D0F815F4-:01AAFCEC255A04F3' and use it as below

SELECT account.id, name, xml, lockinfo, '', modified, counter, '', repoMod from account WHERE ( id := b1 )
 

Solution

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