fetch-size-LIO

fetch-size-lio.sql

SQL> create table t as select * from all_objects where rownum<=1e4;

Table created.

SQL> show arrays
arraysize 15
SQL> set autot trace stat
SQL> select * from t;

10000 rows selected.


Statistics
----------------------------------------------------------
        119  recursive calls
        133  db block gets
        968  consistent gets
        175  physical reads
      26108  redo size
    1313073  bytes sent via SQL*Net to client
       7663  bytes received via SQL*Net from client
        668  SQL*Net roundtrips to/from client
          7  sorts (memory)
          0  sorts (disk)
      10000  rows processed

SQL> select * from t;

10000 rows selected.


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        832  consistent gets
          0  physical reads
          0  redo size
    1313073  bytes sent via SQL*Net to client
       7663  bytes received via SQL*Net from client
        668  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      10000  rows processed

SQL> select * from t;

10000 rows selected.


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        832  consistent gets
          0  physical reads
          0  redo size
    1313073  bytes sent via SQL*Net to client
       7663  bytes received via SQL*Net from client
        668  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      10000  rows processed

SQL> set arrays 5000
SQL> select * from t;

10000 rows selected.


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        180  consistent gets
          0  physical reads
          0  redo size
    1249914  bytes sent via SQL*Net to client
        348  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      10000  rows processed