TABLE NUM_ROWS BLOCKS
----- ---------- ----------
T 201653 1000
 
  
SQL> set autotrace traceonly ;
SQL> select * from t;
 
  
201653 rows selected.
 
  
Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873
 
  
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 201K| 5513K| 227 (4)| 00:00:03 |
| 1 | TABLE ACCESS FULL| T | 201K| 5513K| 227 (4)| 00:00:03 |
--------------------------------------------------------------------------
 
  
Statistics
----------------------------------------------------------
 156 recursive calls
 0 db block gets
14384 consistent gets ---逻辑读
 0 physical reads
 0 redo size
 8596453 bytes sent via SQL*Net to client
 148258 bytes received via SQL*Net from client
 13445 SQL*Net roundtrips to/from client
 2 sorts (memory)
 0 sorts (disk)
 201653 rows processed
 
  
SQL> select * from t;
 
  
201653 rows selected.
 
  

Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873
 
  
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 201K| 5513K| 227 (4)| 00:00:03 |
| 1 | TABLE ACCESS FULL| T | 201K| 5513K| 227 (4)| 00:00:03 |
--------------------------------------------------------------------------
 
  

Statistics
----------------------------------------------------------
 0 recursive calls
 0 db block gets
 14368 consistent gets
 0 physical reads
 0 redo size
 8596453 bytes sent via SQL*Net to client
 148258 bytes received via SQL*Net from client
 13445 SQL*Net roundtrips to/from client
 0 sorts (memory)
 0 sorts (disk)
 201653 rows processed
SQL> show arraysize;
arraysize 15
arraysize 15表示从Oracle服务器端一次只传递15行记录到客户端,增大此值会改变查询的逻辑读。
 
  
SQL> set arraysize 500;
SQL> select * from t;
 
  
201653 rows selected.
 
  

Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873
 
  
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 201K| 5513K| 227 (4)| 00:00:03 |
| 1 | TABLE ACCESS FULL| T | 201K| 5513K| 227 (4)| 00:00:03 |
--------------------------------------------------------------------------
 
  
Statistics
----------------------------------------------------------
 0 recursive calls
 0 db block gets
 1393 consistent gets
 0 physical reads
 0 redo size
 6901253 bytes sent via SQL*Net to client
 4818 bytes received via SQL*Net from client
 405 SQL*Net roundtrips to/from client
 0 sorts (memory)
 0 sorts (disk)
 201653 rows processed