...

• * Set to native (JDBC) connection type
• * Leave hostname and port empty (this is also working with a port setting of -1)
• * Set the database name to something like this...
  (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host1-vip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host2-vip)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = db-service)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))

...

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.