归档模式
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
-------------------------------------------------------
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
-------------------------------------------------------