Mega Code Archive
Set arraysize 5
<![CDATA[
SQL>
SQL> create table t as select * from all_objects;
Table created.
SQL>
SQL> set autotrace traceonly statistics;
SQL>
SQL> set arraysize 2
SQL> select * from t;
12652 rows selected.
Statistics
----------------------------------------------------------
288 recursive calls
0 db block gets
6498 consistent gets
160 physical reads
0 redo size
1312833 bytes sent via SQL*Net to client
69955 bytes received via SQL*Net from client
6327 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
12652 rows processed
SQL>
SQL> set arraysize 5
SQL> select * from t;
12652 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
2672 consistent gets
0 physical reads
0 redo size
830868 bytes sent via SQL*Net to client
28210 bytes received via SQL*Net from client
2532 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
12652 rows processed
SQL> set arraysize 10
SQL> select * from t;
12652 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
1416 consistent gets
0 physical reads
0 redo size
670213 bytes sent via SQL*Net to client
14295 bytes received via SQL*Net from client
1267 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
12652 rows processed
SQL> set arraysize 15
SQL> select * from t;
12652 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
1004 consistent gets
0 physical reads
0 redo size
616619 bytes sent via SQL*Net to client
9653 bytes received via SQL*Net from client
845 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
12652 rows processed
SQL> set arraysize 100
SQL> select * from t;
12652 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
289 consistent gets
0 physical reads
0 redo size
525560 bytes sent via SQL*Net to client
1766 bytes received via SQL*Net from client
128 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
12652 rows processed
SQL> set arraysize 5000
SQL> select * from t;
12652 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
167 consistent gets
0 physical reads
0 redo size
509812 bytes sent via SQL*Net to client
402 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
12652 rows processed
SQL> set autotrace off
SQL>
SQL> drop table t;
Table dropped.
SQL>
]]>