In addition to standard ODBC functions, users can leverage Oracle specific features for high performance data access. The Oracle ODBC driver for Oracle Database enables ODBC applications to connect to Oracle Database. ODBC driver configuration to a higher number such as 100 or even higher. Oracle ODBC drivers, Fetch Buffer Size = 64000. Do you know why Microsoft ODBC Drivers seems to be more performant than. The maximum number of rows is calculated using the MEMLIM value and the maximum size of one row. This property determines the maximum number of rows that the driver can retrieve each time during array fetches. The minimum value for the buffer size is 32 KB. The size of the buffer that the driver uses for data retrieval, in bytes. 5 Enter the following configuration details. Download Template Zw Jam Minimalist here. The Oracle ODBC Driver Configuration dialog displays. 3 Select Oracle in OraDB11g_home1 from the list (or similar, depending on the ODBC installation).Ĥ Click on the Finish button. The Create New Data Source dialog displays, enabling you to add a new DSN. You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting Tools ODBC Data Sources in the Enterprise Architect menu bar The ODBC Data Source Administrator window displays.