体系架构

界面风格

模块组成

模块标准功能

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>Oracle培训; 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>oracle代理; 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