When creating a table or index in parallel, each parallel execution server uses the values in the STORAGE clause of the CREATE statement to create temporary segments to store the rows. Therefore, a table created with a NEXT setting of 5 MB and a PARALLEL DEGREE of 12 consumes at least 60 megabytes (MB) of storage during table creation because each process starts with an extent of 5 MB.

为了理解这段话，我做了如下实验：

sqlplus "/as sysdba"

alter session set events '10046 trace name context forever,level 4';

create table monitor.test parallel 3 as select * from bss1.PTMPLOGIN894_200811;

alter session set events '10046 trace name conext off';

并在执行CTAS过程中检查了一下视图dba_segments，发现在CTAS过程中出现了三个临时段，再看下，10046的trace，这里最好不要tkprof，因为需要看绑定变量和执行过程；前面的都是些select系统表，可以跳过去；

=====================
PARSING IN CURSOR #1 len=37 dep=1 uid=0 ct=3 lid=0 tim=12176337307093 hv=2907401737 ad='ce220878'
SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL
END OF STMT
PARSE #1:c=0,e=128,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337307089
BINDS #1:
EXEC #1:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337307245
=====================
PARSING IN CURSOR #6 len=129 dep=2 uid=0 ct=6 lid=0 tim=12176337307451 hv=2635489469 ad='89959708'
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1
END OF STMT
PARSE #6:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=12176337307448
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=700000189613fd0 bln=24 avl=02 flg=09
value=1
Bind#1
acdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=700000189613fe2 bln=24 avl=02 flg=09
value=1
Bind#2
acdty=02 mxl=22(05) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=700000189613ff4 bln=24 avl=05 flg=09
value=4294967
Bind#3
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105cf760 bln=24 avl=02 flg=05
value=1
Bind#4
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105cf730 bln=24 avl=01 flg=05
value=0
Bind#5
acdty=02 mxl=22(01) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=700000189614006 bln=24 avl=01 flg=09
value=0
Bind#6
acdty=02 mxl=22(04) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=700000189614018 bln=24 avl=04 flg=09
value=37750
Bind#7
acdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=70000018961402a bln=32 avl=32 flg=09
value="--------------------------------"
Bind#8
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105cf700 bln=24 avl=01 flg=05
value=0
Bind#9
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105cf790 bln=22 avl=03 flg=05
value=260
EXEC #6:c=0,e=1314,p=0,cr=1,cu=2,mis=0,r=1,dep=2,og=4,tim=12176337308892
STAT #6 id=1 cnt=1 pid=0 pos=1 bj=0 p='UPDATE SEQ$ (cr=1 pr=0 pw=0 time=606 us)'
STAT #6 id=2 cnt=1 pid=1 pos=1 bj=102 p='INDEX UNIQUE SCAN I_SEQ1 (cr=1 pr=0 pw=0 time=24 us)'
FETCH #1:c=10000,e=1914,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=4,tim=12176337309186
STAT #1 id=1 cnt=1 pid=0 pos=1 bj=260 p='SEQUENCE ORA_TQ_BASE$ (cr=1 pr=0 pw=0 time=1927 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 bj=0 p='FAST DUAL (cr=0 pr=0 pw=0 time=4 us)'
=====================
PARSING IN CURSOR #7 len=78 dep=0 uid=0 ct=1 lid=0 tim=12176337310309 hv=3958894896 ad='89cd9600'
create table monitor.test parallel 3 as select * from bss1.PTMPLOGIN894_200811
END OF STMT
PARSE #7:c=40000,e=105441,p=5,cr=184,cu=3,mis=1,r=0,dep=0,og=1,tim=12176337310306
BINDS #7:
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 ct=3 lid=0 tim=12176337310827 hv=854877822 ad='ccebddc0'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=127,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337310824
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105d0be8 bln=22 avl=04 flg=05
value=72150
EXEC #2:c=0,e=134,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337311109
FETCH #2:c=0,e=35,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337311172
STAT #2 id=1 cnt=0 pid=0 pos=1 bj=18 p='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=2 pr=0 pw=0 time=43 us)'
STAT #2 id=2 cnt=0 pid=1 pos=1 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=35 us)'
=====================
PARSING IN CURSOR #6 len=205 dep=1 uid=0 ct=2 lid=0 tim=12176337311373 hv=3861105107 ad='cea2c110'
insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2)values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16, :17)
END OF STMT
PARSE #6:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337311371
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fbbe8 bln=22 avl=02 flg=05
value=48
Bind#1
acdty=01 mxl=32(04) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=7000001ce918c5e bln=32 avl=04 flg=09
value="TEST"
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fbbb8 bln=24 avl=02 flg=05
value=1
Bind#3
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fbb88 bln=24 avl=04 flg=05
value=72150
Bind#4
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fbb58 bln=24 avl=02 flg=05
value=2
Bind#5
acdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=8 ff=0
kxsbbbfp=7000001ce918d51 bln=08 avl=07 flg=09
value="3/27/2009 20:16:25"
Bind#6
acdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=8 ff=0
kxsbbbfp=7000001ce918d58 bln=08 avl=07 flg=09
value="3/27/2009 20:16:25"
Bind#7
acdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=8 ff=0
kxsbbbfp=7000001ce918d5f bln=08 avl=07 flg=09
value="3/27/2009 20:16:25"
Bind#8
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fbb28 bln=24 avl=02 flg=05
value=1
Bind#9
acdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#10
acdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#11
acdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#12
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fbaf8 bln=24 avl=04 flg=05
value=72150
Bind#13
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fbab8 bln=24 avl=01 flg=05
value=0
Bind#14
acdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=32 ff=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#15
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fb7d0 bln=24 avl=02 flg=05
value=6
Bind#16
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105fb7a0 bln=24 avl=02 flg=05
value=1
EXEC #6:c=0,e=1808,p=0,cr=1,cu=6,mis=0,r=1,dep=1,og=4,tim=12176337313379
=====================
PARSING IN CURSOR #2 len=51 dep=1 uid=0 ct=6 lid=0 tim=12176337313666 hv=2404924642 ad='9df0a0b8'
update con$ set con#=:3 where owner#=:1 and name=:2
END OF STMT
PARSE #2:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337313664
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105d0388 bln=24 avl=04 flg=05
value=140714
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105d03b8 bln=22 avl=01 flg=05
value=0
Bind#2
acdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=7000001ccd629f6 bln=32 avl=16 flg=09
value="_NEXT_CONSTRAINT"
EXEC #2:c=0,e=1239,p=0,cr=2,cu=7,mis=0,r=1,dep=1,og=4,tim=12176337315015
STAT #2 id=1 cnt=1 pid=0 pos=1 bj=0 p='UPDATE CON$ (cr=2 pr=0 pw=0 time=986 us)'
STAT #2 id=2 cnt=1 pid=1 pos=1 bj=48 p='INDEX UNIQUE SCAN I_CON1 (cr=2 pr=0 pw=0 time=39 us)'
=====================
PARSING IN CURSOR #6 len=49 dep=1 uid=0 ct=3 lid=0 tim=12176337315309 hv=2297137822 ad='cdc19918'
select con# from con$ where owner#=:1 and name=:2
END OF STMT
PARSE #6:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337315306
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105a36c8 bln=22 avl=02 flg=05
value=48
Bind#1
acdty=01 mxl=32(13) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=1105a3690 bln=32 avl=13 flg=05
value="SYS_C00140713"
EXEC #6:c=0,e=182,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337315602
FETCH #6:c=0,e=24,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337315654
STAT #6 id=1 cnt=0 pid=0 pos=1 bj=28 p='TABLE ACCESS BY INDEX ROWID CON$ (cr=2 pr=0 pw=0 time=34 us)'
STAT #6 id=2 cnt=0 pid=1 pos=1 bj=48 p='INDEX UNIQUE SCAN I_CON1 (cr=2 pr=0 pw=0 time=25 us)'
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105d0388 bln=24 avl=04 flg=05
value=140715
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105d03b8 bln=22 avl=01 flg=05
value=0
Bind#2
acdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=7000001ccd629f6 bln=32 avl=16 flg=09
value="_NEXT_CONSTRAINT"
=====================
PARSING IN CURSOR #2 len=51 dep=1 uid=0 ct=6 lid=0 tim=12176337317012 hv=2404924642 ad='9df0a0b8'
update con$ set con#=:3 where owner#=:1 and name=:2
END OF STMT
EXEC #2:c=0,e=1168,p=0,cr=2,cu=6,mis=0,r=1,dep=1,og=4,tim=12176337317009
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105a36c8 bln=22 avl=02 flg=05
value=48
Bind#1
acdty=01 mxl=32(13) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=1105a3690 bln=32 avl=13 flg=05
value="SYS_C00140714"
=====================
PARSING IN CURSOR #6 len=49 dep=1 uid=0 ct=3 lid=0 tim=12176337317383 hv=2297137822 ad='cdc19918'
select con# from con$ where owner#=:1 and name=:2
END OF STMT
EXEC #6:c=0,e=170,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337317381
FETCH #6:c=0,e=15,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337317466
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105d0388 bln=24 avl=04 flg=05
value=140716
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105d03b8 bln=22 avl=01 flg=05
value=0
Bind#2
acdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=7000001ccd629f6 bln=32 avl=16 flg=09
value="_NEXT_CONSTRAINT"
=====================
PARSING IN CURSOR #2 len=51 dep=1 uid=0 ct=6 lid=0 tim=12176337318682 hv=2404924642 ad='9df0a0b8'
update con$ set con#=:3 where owner#=:1 and name=:2
END OF STMT
EXEC #2:c=0,e=1119,p=0,cr=2,cu=6,mis=0,r=1,dep=1,og=4,tim=12176337318679
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105a36c8 bln=22 avl=02 flg=05
value=48
Bind#1
acdty=01 mxl=32(13) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=1105a3690 bln=32 avl=13 flg=05
value="SYS_C00140715"
=====================
PARSING IN CURSOR #6 len=49 dep=1 uid=0 ct=3 lid=0 tim=12176337319023 hv=2297137822 ad='cdc19918'
select con# from con$ where owner#=:1 and name=:2
END OF STMT
EXEC #6:c=0,e=167,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337319021
FETCH #6:c=0,e=13,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337319105
=====================
PARSING IN CURSOR #2 len=150 dep=1 uid=0 ct=3 lid=0 tim=12176337319481 hv=3988833529 ad='ccd57578'
select 1 from sys.streams$_prepare_ddl p where ((p.global_flag = 1 and :1 is null) or (p.global_flag = 0 and p.usrid = :2)) and rownum = 1
END OF STMT
PARSE #2:c=0,e=95,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337319478
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=00 fl2=0001 frm=00 csi=00 siz=48 ff=0
kxsbbbfp=1105f83c0 bln=22 avl=02 flg=05
value=48
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=00 fl2=0001 frm=00 csi=00 siz=0 ff=24
kxsbbbfp=1105f83d8 bln=22 avl=02 flg=01
value=48
EXEC #2:c=0,e=180,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337319742
FETCH #2:c=0,e=20,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=12176337319782
STAT #2 id=1 cnt=0 pid=0 pos=1 bj=0 p='COUNT STOPKEY (cr=1 pr=0 pw=0 time=29 us)'
STAT #2 id=2 cnt=0 pid=1 pos=1 bj=625 p='INDEX FULL SCAN I_STREAMS_PREPARE_DDL (cr=1 pr=0 pw=0 time=22 us)'
*** 2009-03-27 20:16:37.089
=====================
PARSING IN CURSOR #6 len=296 dep=1 uid=0 ct=6 lid=0 tim=12176348865063 hv=2379717279 ad='cdf52788'
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #6:c=0,e=119,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176348865057
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebae0 bln=24 avl=02 flg=05
value=3
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb778 bln=24 avl=04 flg=05
value=33392
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb748 bln=24 avl=03 flg=05
value=175
Bind#3
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb718 bln=24 avl=02 flg=05
value=1
Bind#4
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb6e8 bln=24 avl=06 flg=05
value=2147483645
Bind#5
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb6b8 bln=24 avl=03 flg=05
value=128
Bind#6
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb688 bln=24 avl=01 flg=05
value=0
Bind#7
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb658 bln=24 avl=02 flg=05
value=48
Bind#8
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb628 bln=24 avl=02 flg=05
value=8
Bind#9
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb5f8 bln=24 avl=01 flg=05
value=0
Bind#10
No oacdef for this bind.
Bind#11
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb5c8 bln=24 avl=01 flg=05
value=0
Bind#12
No oacdef for this bind.
Bind#13
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb598 bln=24 avl=01 flg=05
value=0
Bind#14
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb568 bln=24 avl=04 flg=05
value=72150
Bind#15
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb538 bln=24 avl=04 flg=05
value=131329
Bind#16
No oacdef for this bind.
Bind#17
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb508 bln=24 avl=01 flg=05
value=0
Bind#18
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb90 bln=22 avl=02 flg=05
value=4
Bind#19
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb60 bln=24 avl=02 flg=05
value=4
Bind#20
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb30 bln=24 avl=04 flg=05
value=71692
EXEC #6:c=0,e=1581,p=0,cr=5,cu=1,mis=0,r=1,dep=1,og=4,tim=12176348866928
STAT #6 id=1 cnt=0 pid=0 pos=1 bj=0 p='UPDATE SEG$ (cr=5 pr=0 pw=0 time=356 us)'
STAT #6 id=2 cnt=1 pid=1 pos=1 bj=14 p='TABLE ACCESS CLUSTER SEG$ (cr=5 pr=0 pw=0 time=170 us)'
STAT #6 id=3 cnt=1 pid=2 pos=1 bj=9 p='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=28 us)'
=====================
PARSING IN CURSOR #2 len=56 dep=1 uid=0 ct=7 lid=0 tim=12176348867253 hv=1954230687 ad='89873560'
delete from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #2:c=0,e=120,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176348867251
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebff8 bln=22 avl=02 flg=05
value=4
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebfc8 bln=24 avl=02 flg=05
value=4
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebf98 bln=24 avl=04 flg=05
value=16260
EXEC #2:c=0,e=578,p=0,cr=5,cu=1,mis=0,r=1,dep=1,og=4,tim=12176348867950
STAT #2 id=1 cnt=0 pid=0 pos=1 bj=0 p='DELETE SEG$ (cr=5 pr=0 pw=0 time=322 us)'
STAT #2 id=2 cnt=1 pid=1 pos=1 bj=14 p='TABLE ACCESS CLUSTER SEG$ (cr=5 pr=0 pw=0 time=148 us)'
STAT #2 id=3 cnt=1 pid=2 pos=1 bj=9 p='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=19 us)'
=====================
PARSING IN CURSOR #6 len=296 dep=1 uid=0 ct=6 lid=0 tim=12176348875247 hv=2379717279 ad='cdf52788'
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #6:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176348875241
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebae0 bln=24 avl=02 flg=05
value=3
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb778 bln=24 avl=04 flg=05
value=50032
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb748 bln=24 avl=03 flg=05
value=263
Bind#3
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb718 bln=24 avl=02 flg=05
value=1
Bind#4
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb6e8 bln=24 avl=06 flg=05
value=2147483645
Bind#5
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb6b8 bln=24 avl=03 flg=05
value=128
Bind#6
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb688 bln=24 avl=01 flg=05
value=0
Bind#7
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb658 bln=24 avl=02 flg=05
value=48
Bind#8
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb628 bln=24 avl=02 flg=05
value=8
Bind#9
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb5f8 bln=24 avl=01 flg=05
value=0
Bind#10
No oacdef for this bind.
Bind#11
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb5c8 bln=24 avl=01 flg=05
value=0
Bind#12
No oacdef for this bind.
Bind#13
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb598 bln=24 avl=01 flg=05
value=0
Bind#14
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb568 bln=24 avl=04 flg=05
value=72150
Bind#15
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb538 bln=24 avl=04 flg=05
value=131329
Bind#16
No oacdef for this bind.
Bind#17
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb508 bln=24 avl=01 flg=05
value=0
Bind#18
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb90 bln=22 avl=02 flg=05
value=4
Bind#19
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb60 bln=24 avl=02 flg=05
value=4
Bind#20
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb30 bln=24 avl=04 flg=05
value=71692
EXEC #6:c=0,e=1510,p=0,cr=5,cu=1,mis=0,r=1,dep=1,og=4,tim=12176348877006
STAT #6 id=1 cnt=0 pid=0 pos=1 bj=0 p='UPDATE SEG$ (cr=5 pr=0 pw=0 time=318 us)'
STAT #6 id=2 cnt=1 pid=1 pos=1 bj=14 p='TABLE ACCESS CLUSTER SEG$ (cr=5 pr=0 pw=0 time=149 us)'
STAT #6 id=3 cnt=1 pid=2 pos=1 bj=9 p='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=25 us)'
=====================
PARSING IN CURSOR #2 len=56 dep=1 uid=0 ct=7 lid=0 tim=12176348877219 hv=1954230687 ad='89873560'
delete from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #2:c=0,e=19,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176348877217
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebff8 bln=22 avl=02 flg=05
value=4
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebfc8 bln=24 avl=02 flg=05
value=4
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebf98 bln=24 avl=03 flg=05
value=71700
EXEC #2:c=0,e=473,p=0,cr=5,cu=1,mis=0,r=1,dep=1,og=4,tim=12176348877799
STAT #2 id=1 cnt=0 pid=0 pos=1 bj=0 p='DELETE SEG$ (cr=5 pr=0 pw=0 time=243 us)'
STAT #2 id=2 cnt=1 pid=1 pos=1 bj=14 p='TABLE ACCESS CLUSTER SEG$ (cr=5 pr=0 pw=0 time=127 us)'
STAT #2 id=3 cnt=1 pid=2 pos=1 bj=9 p='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=15 us)'
=====================
PARSING IN CURSOR #6 len=296 dep=1 uid=0 ct=6 lid=0 tim=12176348878119 hv=2379717279 ad='cdf52788'
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #6:c=0,e=21,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176348878116
BINDS #6:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebae0 bln=24 avl=02 flg=05
value=3
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb778 bln=24 avl=04 flg=05
value=50032
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb748 bln=24 avl=03 flg=05
value=263
Bind#3
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb718 bln=24 avl=02 flg=05
value=1
Bind#4
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb6e8 bln=24 avl=06 flg=05
value=2147483645
Bind#5
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb6b8 bln=24 avl=03 flg=05
value=128
Bind#6
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb688 bln=24 avl=01 flg=05
value=0
Bind#7
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb658 bln=24 avl=02 flg=05
value=48
Bind#8
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb628 bln=24 avl=02 flg=05
value=8
Bind#9
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb5f8 bln=24 avl=01 flg=05
value=0
Bind#10
No oacdef for this bind.
Bind#11
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb5c8 bln=24 avl=01 flg=05
value=0
Bind#12
No oacdef for this bind.
Bind#13
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb598 bln=24 avl=01 flg=05
value=0
Bind#14
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb568 bln=24 avl=04 flg=05
value=72150
Bind#15
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb538 bln=24 avl=04 flg=05
value=131329
Bind#16
No oacdef for this bind.
Bind#17
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb508 bln=24 avl=01 flg=05
value=0
Bind#18
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb90 bln=22 avl=02 flg=05
value=4
Bind#19
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb60 bln=24 avl=02 flg=05
value=4
Bind#20
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ebb30 bln=24 avl=04 flg=05
value=71692
EXEC #6:c=0,e=1572,p=0,cr=5,cu=2,mis=0,r=1,dep=1,og=4,tim=12176348879910
STAT #6 id=1 cnt=0 pid=0 pos=1 bj=0 p='UPDATE SEG$ (cr=5 pr=0 pw=0 time=322 us)'
STAT #6 id=2 cnt=1 pid=1 pos=1 bj=14 p='TABLE ACCESS CLUSTER SEG$ (cr=5 pr=0 pw=0 time=136 us)'
STAT #6 id=3 cnt=1 pid=2 pos=1 bj=9 p='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=18 us)'
=====================
PARSING IN CURSOR #2 len=494 dep=1 uid=0 ct=2 lid=0 tim=12176348880409 hv=2283232350 ad='cddc2fa0'
insert into tab$(obj#,ts#,file#,block#,bobj#,tab#,intcols,kernelcols,clucols,audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime,samplesize,cols,property,degree,instances,dataobj#,avgspc_flb,flbcnt,trigflag,spare1,spare6)values(:1,:2,:3,:4,decode(:5,0,null,:5),decode(:6,0,null,:6),:7,:8,decode(:9,0,null,:9),:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,decode(:26,1,null,:26),decode(:27,1,null,:27),:28,:29,:30,:31,:32,:33)
END OF STMT
PARSE #2:c=0,e=128,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12176348880406
BINDS #2:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb308 bln=22 avl=04 flg=05
value=72150
Bind#1
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb2d8 bln=24 avl=02 flg=05
value=4
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb2a8 bln=24 avl=02 flg=05
value=4
Bind#3
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb278 bln=24 avl=04 flg=05
value=71692
Bind#4
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb248 bln=24 avl=01 flg=05
value=0
Bind#5
No oacdef for this bind.
Bind#6
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb218 bln=24 avl=01 flg=05
value=0
Bind#7
No oacdef for this bind.
Bind#8
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb1e8 bln=24 avl=02 flg=05
value=42
Bind#9
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb1b8 bln=24 avl=02 flg=05
value=42
Bind#10
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb188 bln=24 avl=01 flg=05
value=0
Bind#11
No oacdef for this bind.
Bind#12
acdty=01 mxl=128(38) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=128 ff=0
kxsbbbfp=7000001b6d4c104 bln=128 avl=38 flg=09
value="--------------------------------------"
Bind#13
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb158 bln=24 avl=06 flg=05
value=1073741825
Bind#14
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb128 bln=24 avl=02 flg=05
value=10
Bind#15
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb0f8 bln=24 avl=02 flg=05
value=40
Bind#16
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb0c8 bln=24 avl=02 flg=05
value=1
Bind#17
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb098 bln=24 avl=03 flg=05
value=255
Bind#18
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb038 bln=24 avl=00 flg=05
Bind#19
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb008 bln=24 avl=00 flg=05
Bind#20
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eafd8 bln=24 avl=00 flg=05
Bind#21
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eafa8 bln=24 avl=00 flg=05
Bind#22
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eaf78 bln=24 avl=00 flg=05
Bind#23
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eaf48 bln=24 avl=00 flg=05
Bind#24
acdty=12 mxl=07(00) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=8 ff=0
kxsbbbfp=00000000 bln=08 avl=00 flg=09
Bind#25
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eaef0 bln=24 avl=00 flg=05
Bind#26
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eae60 bln=24 avl=02 flg=05
value=42
Bind#27
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eae30 bln=24 avl=06 flg=05
value=536870912
Bind#28
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eae00 bln=24 avl=02 flg=05
value=3
Bind#29
No oacdef for this bind.
Bind#30
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eadd0 bln=24 avl=02 flg=05
value=1
Bind#31
No oacdef for this bind.
Bind#32
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eada0 bln=24 avl=04 flg=05
value=72150
Bind#33
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eaec0 bln=24 avl=00 flg=05
Bind#34
acdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eae90 bln=24 avl=00 flg=05
Bind#35
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105ead70 bln=24 avl=01 flg=05
value=0
Bind#36
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=1105eb068 bln=24 avl=03 flg=05
value=405
Bind#37
acdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=8 ff=0
kxsbbbfp=7000001b6d4c246 bln=08 avl=07 flg=09
value="3/27/2009 20:16:25"

1、select .owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1

CTAS之后得到obj#是72150

2、update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
把第一个临时段加到test段

delete from seg$ where ts#=:1 and file#=:2 and block#=:3

然后删除第一个临时段

3、update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3

把第二个段加到test段

delete from seg$ where ts#=:1 and file#=:2 and block#=:3

然后删除第二个临时段

4、update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
把第三个临时段加到test段

为什么没有删除第三个临时段呢，其实第三个临时段就是后来的test段

因为在CTAS过程中可以看到三个临时段的header block就是对应的后来test段和两个delete的临时段

5、insert into tab$(obj#,ts#,file#,block#,bobj#,tab#,intcols,kernelcols,clucols,audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime,samplesize,cols,property,degree,instances,dataobj#,avgspc_flb,flbcnt,trigflag,spare1,spare6)values(:1,:2,:3,:4,decode(:5,0,null,:5),decode(:6,0,null,:6),:7,:8,decode(:9,0,null,:9),:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,decode(:26,1,null,:26),decode(:27,1,null,:27),:28,:29,:30,:31,:32,:33)

最后将test表的记录加到tab$表

可见，oracle是通过同时分配三个临时segment来完成parallel的操作

ITPub博客

Space Management for Parallel DDL

最新文章