Validating ODBC Settings for an Oracle Database

Platform: Windows.

This task applies if you are using an Oracle database platform.

This task is a step in Process of Meeting Requirements for an Incremental Repository Merge.

Verify ODBC settings for an Oracle Database

  1. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC_DSN_name.
  2. Right-click the ODBC data source, and select New, then String Value, and enter the following key names:

    • LobPreFetchSize=8388608

    • FetchBufferSize=1048576