看了eygle的一篇关于临时表的BLOG,于是动手测试了一下自己的数据库,发现有同样的BUG

原文:http://www.eygle.com/faq/temp_table.htm

我的测试结果如下:

SQL> create table c1 (c1 number);

表已创建。

SQL> set autotrace trace stat
SQL> insert into c1 select rownum from dba_objects;

已创建7235行。

Statistics
----------------------------------------------------------
797 recursive calls
125 db block gets
5471 consistent gets
41 physical reads
107048 redo size /****这里产生了107K***/
665 bytes sent via SQL*Net to client
657 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
17 sorts (memory)
0 sorts (disk)
7235 rows processed

SQL> drop table c1;

表已丢弃。

SQL> create global temporary table c2 (c1 number);

表已创建。

SQL> insert into c2 select rownum from dba_objects;

已创建7235行。

Statistics
----------------------------------------------------------
8 recursive calls
7431 db block gets
5210 consistent gets
3 physical reads
930128 redo size /***这里却产生了930K***/
670 bytes sent via SQL*Net to client
657 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
7235 rows processed