用直接路径（direct-path）insert提升性能的两种方法(二)

?

SQL>alter table new_object_directpath nologging

SQL> SET TIMING ON

Elapsed: 00:00:00.54

?

（2）insert耗时

SQL> insert into new_object_directpath nologgingselect * from test_dba_objects;

?

1630104 rows created.

?

?

Elapsed: 00:00:12.43

未产生数据redo与undo

（1）建表与修改设定

SQL>create table new_object_directpath as select * from test_dba_objects where 1=2

?

SQL>alter table new_object_directpath nologging

SQL> SET TIMING ON

Elapsed: 00:00:00.54

?

（2）insert耗时

SQL> insert /*+APPEND */ into new_object_directpath select * from test_dba_objects;

?

1630104 rows created.

?

?

Elapsed: 00:00:05.83

未产生数据redo与undo

SQL>create table new_object_directpath as select * from test_dba_objects where 1=2

?

SQL>alter table new_object_directpath nologging

SQL> SET TIMING ON

Elapsed: 00:00:00.54

?

（2）修改表的并行模式

SQL> alter table new_object_directpath parallel 8;

?

（3） insert耗时

SQL> insert /*+parallel (new_object_directpath,8) */ into new_object_directpath select * from test_dba_objects;

?

1630104 rows created.

?

Elapsed: 00:00:05.61

未产生数据redo与undo

?