Oracle中临时表产生过量Redo的说明

Oracle中临时表产生过量Redo的说明
最近,在Oracle9i中你用过临时表吗?
它是否给你带来了性能提高?你注意过么?
--------------------------------------------------------------------------------
好了言归正传.
我们知道临时表在DML操作中可以减少redo的生成,从而在保存中间结果集时可以带来较大的性能提高.
可是,如果你注意到了,在Oracle9i里,临时表可能比常规表还要产生更多的redo:
[oracle@jumper oracle]$ sqlplus eygle/eygle
SQL*Plus: Release 9.2.0.3.0 - Production on Sat Jul 3 16:37:01 2004
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production ----请注意版本
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
SQL> create table ccc1  (c1 number);
Table created.
SQL> set autotrace trace stat
SQL> insert into ccc1 select rownum from dba_objects;
10468 rows created.
Statistics
----------------------------------------------------------
         73  recursive calls
        175  db block gets
      25623  consistent gets
         36  physical reads
     157336  redo size --------------------常规表产生的redo,大约154K
        622  bytes sent via SQL*Net to client
        547  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          2  sorts (memory)
          0  sorts (disk)
      10468  rows processed
SQL> create global temporary table ccc2 (c1 number) ;
 
Table created.
SQL> set autotrace trace stat
SQL> insert into ccc2