Calyx RIM 6.2 CHF 3 Installation Guide

Specify the number of prepared statements per connection in an LRU cache keyed by the SQL query (set to zero disables the cache)

Attention: Please consult with your DBA before making any changes described in this section.
  1. Navigate to the directory <installation drive>:\InSightManager\server\all\deploy and open the file oracle-ds.xml file in Notepad.
  2. Add the following lines to the two sections specified: 
     <jndi-name>ManagerDS</jndi-name> 
 <prepared-statement-cachesize>100</prepared-statementcache-size>

    and 

    
<jndi-name>DefaultDS</jndiname>
 <prepared-statement-cachesize>100</prepared-statementcache-size>
    Note: It is just example for modifying value prepared-statementcache-size. Setting this to zero disables the cache.
  3. Save and close the file.