体系架构
界面风格
模块组成
模块标准功能
ETL@RACTEST> ETL@RACTEST>
begin
2 for i in 110000 loop
3 insert into test values (i);
4 end loop;
5 end;
6 / PL/SQL procedure successfully
completed. Elapsed: 00:00:00.44 ETL@RACTEST> set autot trace
ETL@RACTEST>
ETL@RACTEST>; select *
from test;
10000 rows selected. Elapsed:
00:00:00.05 Execution Plan Plan hash value: 1357081020
b9a315bf10497b7c8bdb9a8b126f7b-- |
Id | Operation
| Name | Rows | Bytes | Cost
(%CPU)| Time
| |
0 | SELECT STATEMENT |
| 10000 |
126K|
6
(0)| 00:00:01 | |
1 | TABLE ACCESS FULL| TEST | 10000
|
126K|
6 (0)| 00:00:01 |
1b184647115e9e1cef9c68ba9c6eaf-e1afa0c7c00486aada4e03270f8958-
Note
- dynamic sampling used for this
statement Statistics
0 recursive calls
0 db block gets
690 consistent gets
0 physical reads
0 redo size
214231 bytes sent via SQL*Net to
client
7791 bytes received via SQL*Net
from client
668 SQL*Net roundtrips to/from
client
0 sorts (memory)
0 sorts (disk)
10000 rows processed 可以看到select
*读了690个内存块。
ETL@RACTEST>; select *
from test order by 1;
10000 rows selected. Elapsed:
00:00:00.04 Execution Plan Plan hash value: 2007178810
| Id | Operation
| Name | Rows | Bytes | Cost
(%CPU)| Time
| | 0 | SELECT STATEMENT |
| 10000 | 126K|
7 (15)| 00:00:01 | | 1 | SORT ORDER
BY
|
| 10000 |
126K|
7
(15)| 00:00:01 | | 2 |
TABLE ACCESS FULL| TEST | 10000 |
126K|
6 (0)| 00:00:01 | - Note
- dynamic sampling used for this
statement Statistics
0 recursive calls
0 db block gets
23 consistent gets
0 physical reads
0 redo size
174288 bytes sent via SQL*Net to
client
7791 bytes received via SQL*Net
from client
668 SQL*Net roundtrips to/from
client
1 sorts (memory)
0 sorts (disk)
10000 rows
processed