ITPub博客

首页 > 数据库 > Oracle > 向不了解oracle EBS的人介绍Oracle EBS

向不了解oracle EBS的人介绍Oracle EBS

Oracle 作者:neilkooo 时间:2013-05-17 17:12:24 0 删除 编辑

体系架构

界面风格

模块组成

模块标准功能

 

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 

<!-- 正文结束 -->

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9523052/viewspace-1116973/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论