Troubleshooting an Oracle Connection
The solution to the following situation might help you troubleshoot Oracle connections:
- 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 the Oracle connector is 60,000 bytes. You might optimize performance with an 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.