Oracle Connector

Back Next

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.

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.

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. 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

Rename Saved Search

Table of Contents

Oracle Connector

Oracle Connector

Troubleshooting an Oracle connection

Troubleshooting an Oracle connection