If somebody is interested in playing with ARRAY size parameter in Java then the following statement sets it:
((OracleConnection)conn).setDefaultRowPrefetch (Integer.parseInt(args[6]));

The full test code is bellow. I played with that parameter myself and in extreme cases yous might end=up with 10-100 times difference.

Yury (Jurijs)


FULL CODE:

import oracle.jdbc.driver.*;
import java.sql.*;

class J {
public static void main (String args []) throws SQLException {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@"+ args[0], args[1], args[2]);

//Set the default row prefetch setting for this connection def=10

//-----======<<<<< !!!!!
((OracleConnection)conn).setDefaultRowPrefetch (Integer.parseInt(args[6]));
//-----======<<<<< !!!!!


System.out.println ("BEGIN");

Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery (args[3]);
String vcounter = "0";

while (rset.next ()) {
vcounter=rset.getString (1);
try {java.lang.Thread.sleep(Integer.parseInt(args[4]));} catch (InterruptedException e) {}
}

rset.close();
System.out.println ("END");
}
}


the way to execute it is:
java J "host:1521:SID" user password "select * from testf where rownum < 100001" 0 0 <array size>

Java programmers never use JDBC interface. :) It's all abstracted behind some kind of obj-rel mapping. :)

but seriously, thanks for info - good to know.