set arraysize 5 : autotrace « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. autotrace

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>
SQL>