knex · justin-cotarla · Apr 29, 2025 · Apr 29, 2025 · Apr 29, 2025
diff --git a/docs/src/guide/index.md b/docs/src/guide/index.md
@@ -58,12 +58,9 @@ const pg = require('knex')({
 });
 ```
 
-:::
-
-When using the PostgreSQL driver, another usage pattern for instantiating the Knex configuration object could be to use a `connection: {}` object details to specify various flags such as enabling SSL, a connection string, and individual connection configuration fields all in the same object. Consider the following example:
+Another usage pattern for instantiating the Knex configuration object could be to use a `connection: {}` object details to specify various flags such as enabling SSL, a connection string, and individual connection configuration fields all in the same object.
 
-::: info PostgreSQL
-If `connectionString` is highest priority to use. If left unspecified then connection details will be determined using the individual connection fields (`host`, `port`, etc), and finally an SSL configuration will be enabled based on a truthy value of `config["DB_SSL"]` which will also accept self-signed certificates.
+The `connectionString` takes priority over other connections fields if set. If left unspecified then connection details will be determined using the individual connection fields (`host`, `port`, etc), and finally an SSL configuration will be enabled based on a truthy value of `config["DB_SSL"]` which will also accept self-signed certificates.
 
 ```js
 const pg = require('knex')({
@@ -82,8 +79,6 @@ const pg = require('knex')({
 
 :::
 
-The following are SQLite usage patterns for instantiating the Knex configuration object:
-
 ::: info SQLite3 or Better-SQLite3
 When you use the SQLite3 or Better-SQLite3 adapter, there is a filename required, not a network connection. For example:
 
@@ -196,6 +191,28 @@ const knex = require('knex')({
 
 :::
 
+::: info OracleDB
+When using the node-oracledb driver, row fetching can be tuned by providing a value for `fetchArraySize`:
+
+```js
+const knex = require('knex')({
+  client: 'oracledb',
+  connection: {
+    host: '127.0.0.1',
+    port: 1521,
+    user: 'your_database_user',
+    password: 'your_database_password',
+    database: 'myapp_test',
+    fetchArraySize: 10000,
+  },
+```
+
+If not provided, `fetchArraySize` falls back to the driver default of 100.
+
+See [Tune Fetch Performance](https://node-oracledb.readthedocs.io/en/latest/user_guide/tuning.html#rowfetching) for more details.
+
+:::
+
 ::: info
 The database version can be added in knex configuration, when you use the PostgreSQL adapter to connect a non-standard database.
 

diff --git a/lib/dialects/oracledb/index.js b/lib/dialects/oracledb/index.js
@@ -142,6 +142,10 @@ class Client_Oracledb extends Client_Oracle {
         this.connectionSettings
       );
 
+      if (this.connectionSettings.fetchArraySize) {
+          this.driver.fetchArraySize = this.connectionSettings.fetchArraySize;
+      }
+
       if (this.connectionSettings.prefetchRowCount) {
         oracleDbConfig.prefetchRows = this.connectionSettings.prefetchRowCount;
       }

diff --git a/lib/dialects/oracledb/utils.js b/lib/dialects/oracledb/utils.js
@@ -113,7 +113,7 @@ function monkeyPatchConnection(connection, client) {
             return cb(err);
           }
           const fetchResult = { rows: [], resultSet: result.resultSet };
-          const numRows = 100;
+          const numRows = client.driver.fetchArraySize;
           const fetchRowsFromRS = function (connection, resultSet, numRows) {
             resultSet.getRows(numRows, function (err, rows) {
               if (err) {

diff --git a/types/index.d.ts b/types/index.d.ts
@@ -3035,6 +3035,7 @@ declare namespace Knex {
     requestTimeout?: number;
     connectString?: string;
     expirationChecker?(): boolean;
+    fetchArraySize?: number;
   }
 
   // Config object for pg: https://github.com/DefinitelyTyped/DefinitelyTyped/blob/master/types/pg/index.d.ts