oracle create table parallel,[Oracle] Create table as 速度测试nologging+parallel

SQL> show user

USER 为 "BRUCE"

SQL> select count(*) from bruce;

COUNT(*)

----------

83324928

SQL> select segment_name,bytes/1024/1024/1024 from user_segments;

SEGMENT_NAME         BYTES/1024/1024/1024

-------------------- --------------------

BRUCE                               8.875

SQL> create table bruce1 as select * from bruce;

表已创建。

已用时间:  00: 07: 46.42

SQL> select segment_name,bytes/1024/1024/1024 from user_segments;

SEGMENT_NAME         BYTES/1024/1024/1024

-------------------- --------------------

BRUCE                               8.875

BRUCE1                             8.9375

SQL> create table bruce2 nologging as select * from bruce;

表已创建。

已用时间:  00: 02: 31.71

SQL> select segment_name,bytes/1024/1024/1024 from user_segments;</