今天 发现一个效率问题 于是做实验验证
create tablespace fixedSize128M_temp1 datafile 'd:\orcldata\128mtemp.dbf' size 128m;
create temporary tablespace test_temp
tempfile 'd:\orcldata\32mtemp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create table fixedSizeT3 tablespace fixedSize128M_temp1
as
select level id, to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ss:ff3') time
from dual connect by level<0;
create table autoSizeT4 tablespace autoSize32to521M_temp1
as
select level id, to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ss:ff3') time
from dual connect by level<0;
insert into fixedSizeT3
select level id, to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ss:ff3') time
from dual connect by level<1000000; ----3.797
insert into autoSizeT4
select level id, to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ss:ff3') time
from dual connect by level<1000000;---- 5.454
1 ROOT FIXEDSIZET3 TABLE ASSM FIXEDSIZE128M_TEMP1 9 642 92274688 11264 82 65536 1048576 1 2147483645 2147483645 9 DEFAULT DEFAULT DEFAULT
2 ROOT AUTOSIZET4 TABLE ASSM AUTOSIZE32TO521M_TEMP1 8 642 39845888 4864 53 65536 1048576 1 2147483645 2147483645 8 DEFAULT DEFAULT DEFAULT
您发现什么没有??