ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Space Management for Parallel DDL

Space Management for Parallel DDL

原创 Linux操作系统 作者:v_fantasy 时间:2009-03-27 22:39:02 0 删除 编辑

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博客 ” ,链接:http://blog.itpub.net/16158219/viewspace-580404/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-10-07

  • 博文量
    98
  • 访问量
    179849