SQL> set arraysize 2
select * from t;SQL>

12211 rows selected.

Elapsed: 00:00:13.30

Statistics
----------------------------------------------------------
        288  recursive calls
          0  db block gets
       6281  consistent gets
        154  physical reads
          0  redo size
    1229761  bytes sent via SQL*Net to client
      67539  bytes received via SQL*Net from client
       6107  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed

SQL> set arraysize 5
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:02.01

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
       2575  consistent gets
          0  physical reads
          0  redo size
     764560  bytes sent via SQL*Net to client
      27246  bytes received via SQL*Net from client
       2444  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed

SQL> set arraysize 10
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:01.18

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
       1365  consistent gets
          0  physical reads
          0  redo size
     609493  bytes sent via SQL*Net to client
      13815  bytes received via SQL*Net from client
       1223  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed

SQL> set arraysize 20
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:03.07

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        764  consistent gets
        155  physical reads
          0  redo size
     531927  bytes sent via SQL*Net to client
       7094  bytes received via SQL*Net from client
        612  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed

SQL> set arraysize 50
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:02.50

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        400  consistent gets
        155  physical reads
          0  redo size
     485445  bytes sent via SQL*Net to client
       3068  bytes received via SQL*Net from client
        246  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed

SQL> set arraysize 100
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:00.74

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        279  consistent gets
        155  physical reads
          0  redo size
     469951  bytes sent via SQL*Net to client
       1726  bytes received via SQL*Net from client
        124  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed
SQL> set arraysize 200
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:00.81

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        220  consistent gets
        154  physical reads
          0  redo size
     462204  bytes sent via SQL*Net to client
       1055  bytes received via SQL*Net from client
         63  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed
SQL> set arraysize 500
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:01.08

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        183  consistent gets
          0  physical reads
          0  redo size
     457505  bytes sent via SQL*Net to client
        648  bytes received via SQL*Net from client
         26  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed

SQL> set arraysize 1000
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:00.51

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        171  consistent gets
          0  physical reads
          0  redo size
     455981  bytes sent via SQL*Net to client
        516  bytes received via SQL*Net from client
         14  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed
SQL> set arraysize 2000
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:00.56

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        165  consistent gets
         72  physical reads
          0  redo size
     455219  bytes sent via SQL*Net to client
        450  bytes received via SQL*Net from client
          8  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed
SQL> set arraysize 5000
SQL> select * from t;

12211 rows selected.

Elapsed: 00:00:00.48

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        161  consistent gets
         72  physical reads
          0  redo size
     454711  bytes sent via SQL*Net to client
        406  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      12211  rows processed