skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Oracle Wire Protocol Driver : Connection Option Descriptions : Array Size
  
Array Size
Attribute
ArraySize (AS)
Purpose
The number of bytes the driver can fetch in a single network round trip. Larger values increase throughput by reducing the number of times the driver fetches data across the network. Smaller values increase response time, as there is less of a delay waiting for the server to transmit data.
Valid Values
An integer from 1 to 4,294,967,296 (4 GB)
The value 1 does not define the number of bytes but, instead, causes the driver to allocate space for exactly one row of data.
Notes
*This connection option can affect performance.
Default
60000
GUI Tab
Performance tab
See also
Performance Considerations