对表进行dml操作时影响产生日志量的几个因素

归档模式
SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u02/archive_log
Oldest online log sequence     29
Next log sequence to archive   31
Current log sequence           31
1.创建测试表hat_objects
SQL> create table hat_objects as select * from all_objects where 1<>1;
 
Table created

2.打开执行计划
SQL> set autotrace traceonly statistics;
3.插入数据
SQL> insert into hat_objects select * from all_objects;

40685 rows created.


Statistics
----------------------------------------------------------
       5877  recursive calls
       5779  db block gets
      80216  consistent gets
      0  physical reads
    4684152  redo size
    675  bytes sent via SQL*Net to client
    585  bytes received via SQL*Net from client
      4  SQL*Net roundtrips to/from client
      2  sorts (memory)
      0  sorts (disk)
      40685  rows processed

4.使用提示插入数据
SQL> insert /*+ append */ into hat_objects select * from all_objects;

40685 rows created.


Statistics
-------------------------------------------------------