Oracle Connector > Troubleshooting > Troubleshooting an Oracle connection
  

Troubleshooting an Oracle connection

The performance of a task that uses an Oracle connection is not optimal.
You can configure certain properties in the Secure Agent to optimize the performance of Oracle Connector.
The following table describes the properties that you can set:
Property
Description
Parameters
Array size
Add the OdbcOracleDefaultArraySize property to increase the array size. Set the value of the property to an appropriate array size, in bytes, based on the amount of data that you want to read or write.
Default is 6000000 bytes.
Note: This property does not optimize performance for custom SQL queries configured in the mapping.
  • - Service: Data Integration Server
  • - Type: DTM
  • - Name: OdbcOracleDefaultArraySize
  • - Value: Array size in bytes. For example, 7000000.
Optimize Oracle write
Configure the Data Integration Server OptimizeOracleSQLServerWrite property to optimize the write operation.
Default is No.
  • - Name: OptimizeOracleSQLServerWrite
  • - Value: Yes
Enable array upsert
Add the EnableArrayUpsert property to optimize batch upserts using arrays to an Oracle target.
  • - Service: Data Integration Server
  • - Type: DTM
  • - Name: EnableArrayUpsert
  • - Value: Yes
Enable array update
Add the EnableArrayUpdate property to optimize batch updates using arrays to an Oracle target.
  • - Service: Data Integration Server
  • - Type: DTM
  • - Name: EnableArrayUpdate
  • - Value: Yes
ERROR: keytool error: java.security.KeyStoreException: TrustedCertEntry not applicable.
You must use Java 1.8 to create a PKCS12 truststore certificate. You cannot create a PKCS12 truststore certificate using Java 1.7.