...

Note: This does only work with a repository based system until 3.0.4. Beginning with 3.0.5 and 3.1 file based systems do also support this.

Performance Considerations: Standard Fetch Size and Row Prefetching

In case you have a slow connection and/or your latency is high (e.g. via a VPN), prefetching data into the client reduces the number of round trips to the server and you can specify the number of rows to fetch with each trip.

Set the defaultRowPrefetch and fetchSize properties in the database connection dialog.

For more information, see Oracle Row Prefetching and Fetch Size in the JDBC Developer's Guide and Reference.