Troubleshooting an Oracle Connection

A task that uses an Oracle connection runs slower. However, an Oracle connection runs fast when you use an ODBC connection for Oracle.

The default array size for Oracle Connector is 60,000 bytes. You might optimize performance of Oracle Connector by increasing the array size. To increase the array size, you can configure the following custom configuration properties for the Secure Agent:

• - Type: Tomcat, Name: ODBCOptimizeRead, Value: Yes
• - Type: Tomcat, Name: OdbcOracleDefaultArraySize, Value: <number of bytes>

For example:

• - Type: Tomcat, Name: ODBCOptimizeRead, Value: Yes
• - Type: Tomcat, Name: OdbcOracleDefaultArraySize: Value: 70000

Note: The OdbcOracleDefaultArraySize custom configuration property does not optimize performance for custom SQL queries.