统计信息
----------------------------------------------------------
? ? ? ? ? 4? recursive calls
? ? ? ? ? 0? db block gets
? ? ? 5239? consistent gets
? ? ? ? ? 0? physical reads
? ? ? ? ? 0? redo size
? ? 3186713? bytes sent via SQL*Net to client
? ? ? 51949? bytes received via SQL*Net from client
? ? ? 4694? SQL*Net roundtrips to/from client
? ? ? ? ? 0? sorts (memory)
? ? ? ? ? 0? sorts (disk)
? ? ? 70384? rows processed
SQL> select /*+ dynamic_sampling(test 10) */ * from test;
已选择70384行。
执行计划
----------------------------------------------------------
Plan hash value: 1357081020
--------------------------------------------------------------------------
| Id? | Operation? ? ? ? | Name | Rows? | Bytes | Cost (%CPU)| Time? ? |
|? 0 | SELECT STATEMENT? |? ? ? | 70384 |? ? 13M|? 197? (2)| 00:00:03 |
|? 1 |? TABLE ACCESS FULL| TEST | 70384 |? ? 13M|? 197? (2)| 00:00:03 |
--------------------------------------------------------------------------
Note
-----
? - dynamic sampling used for this statement (level=2)
统计信息
----------------------------------------------------------
? ? ? ? ? 0? recursive calls
? ? ? ? ? 0? db block gets
? ? ? 5165? consistent gets
? ? ? ? ? 0? physical reads
? ? ? ? ? 0? redo size
? ? 3186713? bytes sent via SQL*Net to client
? ? ? 51949? bytes received via SQL*Net from client
? ? ? 4694? SQL*Net roundtrips to/from client
? ? ? ? ? 0? sorts (memory)
? ? ? ? ? 0? sorts (disk)
? ? ? 70384? rows processed