Tuesday, October 28, 2008

REDO is generated on global temporary tables.

In this test redo on global temporary table = 4% of permanent table.

SQL> insert into perm_table select * from dba_source where rownum < 100000;

99999 rows created.


Statistics
----------------------------------------------------------
1822 recursive calls
27577 db block gets
9419 consistent gets
2 physical reads
20110532 redo size
832 bytes sent via SQL*Net to client
765 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
99999 rows processed

SQL> insert into temp_table select * from dba_source where rownum < 100000;

99999 rows created.


Statistics
----------------------------------------------------------
27 recursive calls
16980 db block gets
6319 consistent gets
0 physical reads
814600 redo size
832 bytes sent via SQL*Net to client
765 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
99999 rows processed