论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2003-01-29 11:31 |只看该作者 |倒序浏览

大家帮忙看看怎么回事？谢谢

*** 2003-01-29 09:21:20.000
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=329591925795 hv=2045994513 ad='6d51122c'
alter session set events '10046 trace name context forever, level 4'
END OF STMT
EXEC #1:c=0,e=26673,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=329591905260
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #1 len=21 dep=0 uid=0 oct=53 lid=0 tim=329598640665 hv=0 ad='9b4f7d4'
drop user zyk cascade
END OF STMT
PARSE #1:c=0,e=19867,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=329598640650
BINDS #1:
=====================
PARSING IN CURSOR #2 len=256 dep=1 uid=0 oct=47 lid=0 tim=329599288202 hv=3505430014 ad='6ed75cf8'
BEGIN
   /* NOP UNLESS A TABLE OBJECT */
   IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active >; 0
   THEN
      sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
   END IF;
   END;
END OF STMT
PARSE #2:c=62500,e=631904,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=329599288186
BINDS #2:
EXEC #2:c=0,e=2887,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=329599321183
=====================
PARSING IN CURSOR #2 len=253 dep=1 uid=35 oct=47 lid=35 tim=329599382348 hv=801458082 ad='6ed6746c'
BEGIN
  IF (xdb.DBMS_XDBZ.is_hierarchy_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
  END IF;
  EXCEPTION
WHEN OTHERS THEN
   null;
END;
END OF STMT
PARSE #2:c=15625,e=58042,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=329599382332
BINDS #2:
BINDS #3:
bind 0: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=64 offset=0
bfp=09bc0bb8 bln=32 avl=00 flg=05
bind 1: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=32
bfp=09bc0bd8 bln=32 avl=03 flg=01
value="ZYK"
=====================
PARSING IN CURSOR #3 len=124 dep=2 uid=35 oct=3 lid=35 tim=329599452168 hv=2193500567 ad='6ed61438'
SELECT COUNT(*) FROM ALL_POLICIES V  WHERE V.OBJECT_OWNER = :b1  AND V.OBJECT_NAME = :b2  AND POLICY_NAME LIKE  '%xdbrls%'
END OF STMT
EXEC #3:c=15625,e=29983,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329599452146
FETCH #3:c=0,e=261,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=329599468591
BINDS #4:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=32 offset=0
bfp=09bc0bd8 bln=32 avl=03 flg=05
value="ZYK"
=====================
PARSING IN CURSOR #4 len=99 dep=2 uid=35 oct=3 lid=35 tim=329599484960 hv=619739417 ad='6ed61244'
SELECT COUNT(*) FROM USER_POLICIES V  WHERE V.OBJECT_NAME = :b1  AND POLICY_NAME LIKE  '%xdbrls%'
END OF STMT
EXEC #4:c=15625,e=12946,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329599484939
FETCH #4:c=0,e=367,p=0,cr=9,cu=0,mis=0,r=1,dep=2,og=4,tim=329599501813
EXEC #2:c=78125,e=87614,p=0,cr=9,cu=0,mis=0,r=1,dep=1,og=4,tim=329599505862
=====================
PARSING IN CURSOR #2 len=234 dep=1 uid=0 oct=3 lid=0 tim=329599753478 hv=2505205034 ad='6ed04104'
select u.name, o2.name, o2.obj# from ind$ i, obj$ o1, obj$ o2, user$ u where o1.owner# = :1  and o1.type# = 2 and i.type# = 9 and i.bo# = o1.obj#  and i.obj# = o2.obj# and o2.owner# = u.user# and i.type# = 9 and o1.owner# != o2.owner#
END OF STMT
PARSE #2:c=15625,e=243610,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329599753463
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5677c bln=22 avl=02 flg=05
value=66
EXEC #2:c=15625,e=165191,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329599936320
FETCH #2:c=0,e=680,p=0,cr=92,cu=0,mis=0,r=0,dep=1,og=4,tim=329599940702
STAT #2 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  '
STAT #2 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  '
STAT #2 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS  '
STAT #2 id=4 cnt=36 pid=3 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #2 id=5 cnt=65 pid=4 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 '
STAT #2 id=6 cnt=0 pid=3 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$ '
STAT #2 id=7 cnt=36 pid=6 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
STAT #2 id=8 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #2 id=9 cnt=0 pid=8 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
STAT #2 id=10 cnt=0 pid=1 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #2 id=11 cnt=0 pid=10 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #2 len=129 dep=1 uid=0 oct=3 lid=0 tim=329600035274 hv=2331739873 ad='6ecfe638'
select u.name, o.name, o.obj# from obj$ o, user$ u, ind$ i where o.owner#=:1 and o.owner#=u.user# and o.obj#=i.obj# and i.type#=9
END OF STMT
PARSE #2:c=0,e=19493,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329600035250
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5677c bln=22 avl=02 flg=05
value=66
EXEC #2:c=15625,e=16836,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329600073260
FETCH #2:c=0,e=454,p=0,cr=79,cu=0,mis=0,r=0,dep=1,og=4,tim=329600078643
=====================
PARSING IN CURSOR #5 len=46 dep=1 uid=0 oct=47 lid=0 tim=329600092393 hv=1265999927 ad='6ed027bc'
begin sys.dbms_cdc_utility.drop_user(:1); end;
END OF STMT
PARSE #5:c=0,e=9614,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329600092379
BINDS #5:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b4e442 bln=32 avl=03 flg=09
value="ZYK"
=====================
PARSING IN CURSOR #6 len=68 dep=2 uid=0 oct=3 lid=0 tim=329600186634 hv=1869512195 ad='6eceda1c'
SELECT NAME FROM SYS.OBJ$  WHERE NAME = 'CDC_CREATE_CTABLE_BEFORE'
END OF STMT
PARSE #6:c=0,e=7194,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,tim=329600186620
BINDS #6:
EXEC #6:c=15625,e=3911,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329600210819
FETCH #6:c=0,e=7317,p=0,cr=279,cu=0,mis=0,r=1,dep=2,og=4,tim=329600222933
FETCH #6:c=0,e=18507,p=2,cr=86,cu=0,mis=0,r=0,dep=2,og=4,tim=329600245864
=====================
PARSING IN CURSOR #7 len=87 dep=2 uid=0 oct=3 lid=0 tim=329600285616 hv=2020431217 ad='6eced828'
SELECT CHANGE_TABLE_NAME FROM SYS.CDC_CHANGE_TABLES$  WHERE CHANGE_TABLE_SCHEMA = :b1
END OF STMT
PARSE #7:c=0,e=34889,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329600285602
BINDS #7:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=13 oacfl2=1 size=32 offset=0
bfp=09b5c420 bln=32 avl=03 flg=05
value="ZYK"
EXEC #7:c=15625,e=21690,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329600327321
FETCH #7:c=0,e=83,p=0,cr=3,cu=0,mis=0,r=0,dep=2,og=4,tim=329600331386
=====================
PARSING IN CURSOR #8 len=63 dep=2 uid=0 oct=3 lid=0 tim=329600358983 hv=3497632171 ad='6eced634'
SELECT HANDLE FROM SYS.CDC_SUBSCRIBERS$  WHERE USERNAME = :b1
END OF STMT
PARSE #8:c=0,e=22331,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329600358970
BINDS #8:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=13 oacfl2=1 size=32 offset=0
bfp=09b550c0 bln=32 avl=03 flg=05
value="ZYK"
EXEC #8:c=31250,e=17593,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329600396875
FETCH #8:c=0,e=81,p=0,cr=3,cu=0,mis=0,r=0,dep=2,og=4,tim=329600401589
EXEC #5:c=156250,e=292669,p=2,cr=371,cu=0,mis=0,r=1,dep=1,og=4,tim=329600405631
STAT #2 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  '
STAT #2 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  '
STAT #2 id=3 cnt=65 pid=2 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #2 id=4 cnt=65 pid=3 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 '
STAT #2 id=5 cnt=0 pid=2 pos=2 obj=19 op='TABLE ACCESS BY INDEX ROWID IND$ '
STAT #2 id=6 cnt=0 pid=5 pos=1 obj=39 op='INDEX UNIQUE SCAN I_IND1 '
STAT #2 id=7 cnt=0 pid=1 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #2 id=8 cnt=0 pid=7 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #2 len=124 dep=1 uid=0 oct=3 lid=0 tim=329600474389 hv=1210012067 ad='6ece85b8'
select vname from sys.snap$ where sowner = :1 and instsite = 0  and (bitand(flag, 268435456) = 0 or bitand(objflag, 32) = 0)
END OF STMT
PARSE #2:c=0,e=31176,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329600474374
BINDS #2:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b7faf0 bln=32 avl=03 flg=05
value="ZYK"
EXEC #2:c=0,e=10295,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329600506755
FETCH #2:c=0,e=202,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=329600507050
=====================
PARSING IN CURSOR #5 len=116 dep=2 uid=0 oct=3 lid=0 tim=329600517816 hv=189272129 ad='6ef9f45c'
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 #5:c=0,e=5862,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329600517802
BINDS #5:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5313c bln=22 avl=03 flg=05
value=178
EXEC #5:c=0,e=681,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329600518741
FETCH #5:c=0,e=65,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=329600518887
STAT #2 id=1 cnt=0 pid=0 pos=1 obj=178 op='TABLE ACCESS FULL SNAP$ '
=====================
PARSING IN CURSOR #2 len=54 dep=1 uid=0 oct=3 lid=0 tim=329600532890 hv=3458549097 ad='6ece49fc'
select name from sys.transformations$ where owner = :1
END OF STMT
PARSE #2:c=0,e=13798,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329600532874
BINDS #2:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b7f198 bln=32 avl=03 flg=05
value="ZYK"
EXEC #2:c=0,e=672,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329600533786
FETCH #2:c=0,e=7120,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=329600540984
=====================
PARSING IN CURSOR #9 len=77 dep=1 uid=0 oct=7 lid=0 tim=329600695931 hv=491984287 ad='6ecdf888'
delete from system.aq$_internet_agent_privs WHERE db_username = NLS_UPPER(:1)
END OF STMT
PARSE #9:c=0,e=154725,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329600695916
BINDS #9:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b4e442 bln=32 avl=03 flg=09
value="ZYK"
EXEC #9:c=0,e=46716,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=329600742794
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
BINDS #5:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5313c bln=22 avl=03 flg=05
value=3690
EXEC #5:c=0,e=170,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329600743245
FETCH #5:c=0,e=8928,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=329600752229
STAT #9 id=2 cnt=0 pid=1 pos=1 obj=3690 op='TABLE ACCESS FULL AQ$_INTERNET_AGENT_PRIVS '
BINDS #5:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5313c bln=22 avl=03 flg=05
value=3475
EXEC #5:c=0,e=223,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329600873272
FETCH #5:c=0,e=12392,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=329600885725
STAT #2 id=1 cnt=0 pid=0 pos=1 obj=3475 op='TABLE ACCESS FULL TRANSFORMATIONS$ '
=====================
PARSING IN CURSOR #2 len=58 dep=1 uid=0 oct=3 lid=0 tim=329600974542 hv=2801247516 ad='6ecd3268'
select name from system.aq$_queue_tables where schema = :1
END OF STMT
PARSE #2:c=0,e=88514,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329600974526
BINDS #2:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b7f198 bln=32 avl=03 flg=05
value="ZYK"
EXEC #2:c=0,e=653,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329600975743
FETCH #2:c=0,e=85,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=329600975904
=====================
PARSING IN CURSOR #9 len=75 dep=1 uid=0 oct=7 lid=0 tim=329601006382 hv=653497786 ad='6eccfdc8'
delete from sys.streams$_propagation_process where source_queue_schema = :1
END OF STMT
PARSE #9:c=0,e=30350,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329601006368
BINDS #9:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b4e442 bln=32 avl=03 flg=09
value="ZYK"
EXEC #9:c=0,e=872,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=329601007402
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
BINDS #5:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5313c bln=22 avl=03 flg=05
value=541
EXEC #5:c=0,e=172,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601007847
FETCH #5:c=0,e=5433,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=329601013561
STAT #9 id=2 cnt=0 pid=1 pos=1 obj=541 op='TABLE ACCESS BY INDEX ROWID STREAMS$_PROPAGATION_PROCESS '
STAT #9 id=3 cnt=0 pid=2 pos=1 obj=543 op='INDEX RANGE SCAN STREAMS$_PROP_P_I2 '
=====================
PARSING IN CURSOR #9 len=111 dep=1 uid=0 oct=3 lid=0 tim=329601029390 hv=2588424143 ad='6ecc96c4'
select o.name from rule_set$ rs, obj$ o, user$ u where u.name = :1 and  o.owner# = u.user# and o.obj# = rs.obj#
END OF STMT
PARSE #9:c=0,e=15046,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329601029376
BINDS #9:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b54974 bln=32 avl=03 flg=05
value="ZYK"
EXEC #9:c=0,e=812,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329601030333
FETCH #9:c=0,e=333,p=0,cr=16,cu=0,mis=0,r=0,dep=1,og=4,tim=329601030708
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  '
STAT #9 id=2 cnt=65 pid=1 pos=1 obj=0 op='NESTED LOOPS  '
STAT #9 id=3 cnt=1 pid=2 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ '
STAT #9 id=4 cnt=1 pid=3 pos=1 obj=44 op='INDEX UNIQUE SCAN I_USER1 '
STAT #9 id=5 cnt=65 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #9 id=6 cnt=65 pid=5 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 '
STAT #9 id=7 cnt=0 pid=1 pos=2 obj=3516 op='INDEX UNIQUE SCAN I_RULE_SET '
=====================
PARSING IN CURSOR #9 len=105 dep=1 uid=0 oct=3 lid=0 tim=329601056084 hv=2616998729 ad='6ecc51ac'
select o.name from rule$ r, obj$ o, user$ u where u.name = :1 and  o.owner# = u.user# and o.obj# = r.obj#
END OF STMT
PARSE #9:c=0,e=24977,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329601056070
BINDS #9:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b54974 bln=32 avl=03 flg=05
value="ZYK"
EXEC #9:c=0,e=812,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329601057029
FETCH #9:c=0,e=314,p=0,cr=16,cu=0,mis=0,r=0,dep=1,og=4,tim=329601057386
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  '
STAT #9 id=2 cnt=65 pid=1 pos=1 obj=0 op='NESTED LOOPS  '
STAT #9 id=3 cnt=1 pid=2 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ '
STAT #9 id=4 cnt=1 pid=3 pos=1 obj=44 op='INDEX UNIQUE SCAN I_USER1 '
STAT #9 id=5 cnt=65 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #9 id=6 cnt=65 pid=5 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 '
STAT #9 id=7 cnt=0 pid=1 pos=2 obj=3522 op='INDEX UNIQUE SCAN I_RULE '
=====================
PARSING IN CURSOR #9 len=110 dep=1 uid=0 oct=3 lid=0 tim=329601077281 hv=4116270115 ad='6ecb7c68'
select o.name from rule_ec$ ec, obj$ o, user$ u where u.name = :1 and  o.owner# = u.user# and o.obj# = ec.obj#
END OF STMT
PARSE #9:c=0,e=19482,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329601077265
BINDS #9:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=10 oacfl2=1 size=32 offset=0
bfp=09b54974 bln=32 avl=03 flg=05
value="ZYK"
EXEC #9:c=0,e=9414,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329601086838
FETCH #9:c=0,e=330,p=0,cr=16,cu=0,mis=0,r=0,dep=1,og=4,tim=329601087221
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  '
STAT #9 id=2 cnt=65 pid=1 pos=1 obj=0 op='NESTED LOOPS  '
STAT #9 id=3 cnt=1 pid=2 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ '
STAT #9 id=4 cnt=1 pid=3 pos=1 obj=44 op='INDEX UNIQUE SCAN I_USER1 '
STAT #9 id=5 cnt=65 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #9 id=6 cnt=65 pid=5 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 '
STAT #9 id=7 cnt=0 pid=1 pos=2 obj=3527 op='INDEX UNIQUE SCAN I_RULE_EC '
=====================
PARSING IN CURSOR #9 len=59 dep=1 uid=0 oct=47 lid=0 tim=329601099749 hv=3020314262 ad='6ecb36e4'
begin dbms_rule_adm.drop_evaluation_context(:1, true); end;
END OF STMT
PARSE #9:c=0,e=12118,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329601099736
BINDS #5:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5313c bln=22 avl=03 flg=05
value=3635
EXEC #5:c=0,e=195,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601109775
FETCH #5:c=0,e=73,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=329601109902
STAT #2 id=1 cnt=0 pid=0 pos=1 obj=3635 op='TABLE ACCESS FULL AQ$_QUEUE_TABLES '
=====================
PARSING IN CURSOR #2 len=490 dep=1 uid=0 oct=3 lid=0 tim=329601165561 hv=423708534 ad='6ecabc80'
select o.name,o.type#,o.obj#,o.remoteowner,o.linkname,o.namespace, o.subname from obj$ o, tab$ t where o.owner#=:1 and o.type# !=11 and o.type# !=13 and o.type# !=14 and o.type# !=10 and o.type# !=33 and o.type# !=32 and o.type# !=8 and o.type# !=9 and o.type# != 7 and o.type# != 38 and o.type# != 28 and o.type# != 29 and o.type# != 30 and o.type# != 55 and o.obj#=t.obj#(+) and (t.property is null or  (bitand(t.property,8192)!=8192 and bitand(t.property,512)!=512))order by o.type# desc
END OF STMT
PARSE #2:c=0,e=55438,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=329601165548
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7faf8 bln=22 avl=02 flg=05
value=66
EXEC #2:c=0,e=6979,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=329601172783
FETCH #2:c=0,e=1241,p=0,cr=97,cu=0,mis=0,r=1,dep=1,og=4,tim=329601174122
=====================
PARSING IN CURSOR #9 len=45 dep=1 uid=0 oct=16 lid=0 tim=329601174509 hv=0 ad='9b4fc04'
drop sequence "ZYK"."MTG_DEPENDENCY_SEQUENCE"
END OF STMT
PARSE #9:c=0,e=232,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=329601174498
BINDS #9:
=====================
PARSING IN CURSOR #10 len=256 dep=2 uid=0 oct=47 lid=0 tim=329601175165 hv=3505430014 ad='6ed75cf8'
BEGIN
   /* NOP UNLESS A TABLE OBJECT */
   IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active >; 0
   THEN
      sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
   END IF;
   END;
END OF STMT
PARSE #10:c=0,e=335,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601175154
BINDS #10:
EXEC #10:c=0,e=213,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=329601175510
=====================
PARSING IN CURSOR #10 len=253 dep=2 uid=35 oct=47 lid=35 tim=329601176101 hv=801458082 ad='6ed6746c'
BEGIN
  IF (xdb.DBMS_XDBZ.is_hierarchy_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
  END IF;
  EXCEPTION
WHEN OTHERS THEN
   null;
END;
END OF STMT
PARSE #10:c=0,e=340,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601176090
BINDS #10:
BINDS #3:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=64 offset=0
bfp=09b4b708 bln=32 avl=03 flg=05
value="ZYK"
bind 1: dty=1 mxl=32(23) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=32
bfp=09b4b728 bln=32 avl=23 flg=01
value="MTG_DEPENDENCY_SEQUENCE"
EXEC #3:c=15625,e=1456,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601177979
FETCH #3:c=0,e=737,p=0,cr=33,cu=0,mis=0,r=1,dep=3,og=4,tim=329601178770
BINDS #4:
bind 0: dty=1 mxl=32(23) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=32 offset=0
bfp=09b4b728 bln=32 avl=23 flg=05
value="MTG_DEPENDENCY_SEQUENCE"
EXEC #4:c=0,e=278,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601179324
FETCH #4:c=0,e=280,p=0,cr=9,cu=0,mis=0,r=1,dep=3,og=4,tim=329601179645
EXEC #10:c=15625,e=3600,p=0,cr=42,cu=0,mis=0,r=1,dep=2,og=4,tim=329601179841
=====================
PARSING IN CURSOR #10 len=291 dep=2 uid=0 oct=3 lid=0 tim=329601189708 hv=2591785020 ad='6efa80f4'
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:6 or subname is null and :6 is null)
END OF STMT
PARSE #10:c=0,e=9457,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601189695
BINDS #10:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b548a4 bln=22 avl=02 flg=05
value=66
bind 1: dty=1 mxl=32(23) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b7fbf0 bln=32 avl=23 flg=05
value="MTG_DEPENDENCY_SEQUENCE"
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b545a8 bln=24 avl=02 flg=05
value=1
bind 3: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b5457c bln=32 avl=00 flg=05
bind 4: (No oacdef for this bind)
bind 5: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b54550 bln=32 avl=00 flg=05
bind 6: (No oacdef for this bind)
bind 7: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b54524 bln=32 avl=00 flg=05
bind 8: (No oacdef for this bind)
EXEC #10:c=0,e=942,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601190909
FETCH #10:c=0,e=93,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=329601191081
=====================
PARSING IN CURSOR #11 len=102 dep=2 uid=0 oct=3 lid=0 tim=329601217585 hv=3023289503 ad='6ef42430'
select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1
END OF STMT
PARSE #11:c=0,e=26358,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601217569
BINDS #11:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b546d0 bln=22 avl=04 flg=05
value=30923
EXEC #11:c=0,e=659,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601218502
FETCH #11:c=0,e=58,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=329601218636
BINDS #11:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b546d0 bln=22 avl=04 flg=05
value=30923
EXEC #11:c=0,e=135,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601219009
FETCH #11:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=329601219096
=====================
PARSING IN CURSOR #13 len=310 dep=2 uid=0 oct=3 lid=0 tim=329601241754 hv=2644650677 ad='6ed7ce1c'
select o.owner#, u.name,       o.name,          o.namespace,       o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.subname  from dependency$ d, obj$ o, user$ u  where d.p_obj#=:1  and (d.p_timestamp=:2 or d.property=2)  and d.d_obj#=o.obj#  and o.owner#=u.user#  and decode(:3,0,0,o.type#)=:3
END OF STMT
PARSE #13:c=0,e=22530,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601241738
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b533e0 bln=22 avl=04 flg=05
value=30923
bind 1: dty=12 mxl=07(07) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=8 offset=0
bfp=09b533cc bln=08 avl=07 flg=05
value="1/17/2003 16:47:16"
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b533a8 bln=24 avl=01 flg=05
value=0
bind 3: (No oacdef for this bind)
EXEC #13:c=15625,e=13590,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601255594
FETCH #13:c=0,e=57,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601255735
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  '
STAT #13 id=3 cnt=0 pid=2 pos=1 obj=96 op='TABLE ACCESS BY INDEX ROWID DEPENDENCY$ '
STAT #13 id=4 cnt=0 pid=3 pos=1 obj=128 op='INDEX RANGE SCAN I_DEPENDENCY2 '
STAT #13 id=5 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #13 id=6 cnt=0 pid=5 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
STAT #13 id=7 cnt=0 pid=1 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #13 id=8 cnt=0 pid=7 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #13 len=34 dep=2 uid=0 oct=7 lid=0 tim=329601284101 hv=440924843 ad='6eca5c38'
delete from context$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=15866,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601284087
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=689,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601284982
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=432 op='INDEX UNIQUE SCAN I_CONTEXT '
=====================
PARSING IN CURSOR #13 len=30 dep=2 uid=0 oct=7 lid=0 tim=329601304010 hv=1539651961 ad='6eca078c'
delete from dir$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=18763,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601303996
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=704,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601304926
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=124 op='INDEX UNIQUE SCAN I_DIR1 '
=====================
PARSING IN CURSOR #13 len=36 dep=2 uid=0 oct=7 lid=0 tim=329601329130 hv=1267976423 ad='6ec9ca34'
delete from type_misc$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=23950,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601329115
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=772,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601330090
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
BINDS #5:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5313c bln=22 avl=03 flg=05
value=295
EXEC #5:c=0,e=138,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601330509
FETCH #5:c=0,e=60,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,tim=329601330622
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=295 op='TABLE ACCESS CLUSTER TYPE_MISC$ '
STAT #13 id=3 cnt=0 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
=====================
PARSING IN CURSOR #13 len=34 dep=2 uid=0 oct=7 lid=0 tim=329601352566 hv=704812413 ad='6ec9c204'
delete from library$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=21744,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601352552
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=740,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601353481
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
BINDS #5:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5313c bln=22 avl=03 flg=05
value=359
EXEC #5:c=0,e=197,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601358477
FETCH #5:c=0,e=70,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,tim=329601358605
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=359 op='TABLE ACCESS CLUSTER LIBRARY$ '
STAT #13 id=3 cnt=0 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
=====================
PARSING IN CURSOR #13 len=36 dep=2 uid=0 oct=7 lid=0 tim=329601381004 hv=3410902463 ad='6eca44fc'
delete from procedure$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=22180,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601380990
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=705,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601381892
=====================
PARSING IN CURSOR #14 len=35 dep=2 uid=0 oct=7 lid=0 tim=329601406796 hv=4035170006 ad='6ec98d4c'
delete from operator$ where obj#=:1
END OF STMT
PARSE #14:c=0,e=24774,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601406781
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30923
EXEC #14:c=0,e=692,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601407668
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=370 op='INDEX UNIQUE SCAN OPER1 '
=====================
PARSING IN CURSOR #14 len=36 dep=2 uid=0 oct=7 lid=0 tim=329601426448 hv=829233079 ad='6ec8fefc'
delete from opbinding$ where obj#=:1
END OF STMT
PARSE #14:c=0,e=18526,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601426433
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30923
EXEC #14:c=15625,e=739,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601427378
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=372 op='INDEX RANGE SCAN OPBIND1 '
=====================
PARSING IN CURSOR #14 len=38 dep=2 uid=0 oct=7 lid=0 tim=329601462356 hv=35434631 ad='6ec8c0c8'
delete from opancillary$ where obj#=:1
END OF STMT
PARSE #14:c=0,e=34723,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601462340
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30923
EXEC #14:c=0,e=744,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601463325
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=374 op='INDEX RANGE SCAN OPANC1 '
=====================
PARSING IN CURSOR #14 len=34 dep=2 uid=0 oct=7 lid=0 tim=329601482109 hv=2533305334 ad='6ec85838'
delete from oparg$ where obj# = :1
END OF STMT
PARSE #14:c=0,e=18525,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601482094
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30923
EXEC #14:c=0,e=733,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601483025
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=376 op='INDEX RANGE SCAN OPARG1 '
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=494,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601483765
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=115 op='INDEX UNIQUE SCAN I_PROCEDURE1 '
=====================
PARSING IN CURSOR #13 len=33 dep=2 uid=0 oct=7 lid=0 tim=329601529831 hv=3605072212 ad='6ec81228'
delete from source$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=45805,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601529816
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24 offset=0
bfp=09b4b800 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=10841,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601540799
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=119 op='INDEX RANGE SCAN I_SOURCE1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601557273 hv=2986507294 ad='6ec7e560'
delete from idl_ub1$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=16115,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601557260
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=721,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601558180
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=120 op='INDEX RANGE SCAN I_IDL_UB11 '
=====================
PARSING IN CURSOR #13 len=47 dep=2 uid=0 oct=7 lid=0 tim=329601602288 hv=3040803786 ad='6ec7c8a0'
delete from idl_char$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=43849,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601602275
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=720,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601603207
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=121 op='INDEX RANGE SCAN I_IDL_CHAR1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601642821 hv=2040504303 ad='6ec77a48'
delete from idl_ub2$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=39347,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601642807
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=728,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601643734
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=122 op='INDEX RANGE SCAN I_IDL_UB21 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601661412 hv=2589750466 ad='6ec78848'
delete from idl_sb4$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=17379,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601661397
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=745,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601662345
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=123 op='INDEX RANGE SCAN I_IDL_SB41 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601662715 hv=2986507294 ad='6ec7e560'
delete from idl_ub1$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=98,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601662706
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=231,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601663073
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=120 op='INDEX RANGE SCAN I_IDL_UB11 '
=====================
PARSING IN CURSOR #13 len=47 dep=2 uid=0 oct=7 lid=0 tim=329601663372 hv=3040803786 ad='6ec7c8a0'
delete from idl_char$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601663363
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=208,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601663710
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=121 op='INDEX RANGE SCAN I_IDL_CHAR1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601664001 hv=2040504303 ad='6ec77a48'
delete from idl_ub2$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=87,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601663992
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=203,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601664329
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=122 op='INDEX RANGE SCAN I_IDL_UB21 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601664611 hv=2589750466 ad='6ec78848'
delete from idl_sb4$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=79,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601664602
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=573,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601666187
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=123 op='INDEX RANGE SCAN I_IDL_SB41 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601666586 hv=2986507294 ad='6ec7e560'
delete from idl_ub1$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=97,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601666577
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=231,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601666985
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=120 op='INDEX RANGE SCAN I_IDL_UB11 '
=====================
PARSING IN CURSOR #13 len=47 dep=2 uid=0 oct=7 lid=0 tim=329601667282 hv=3040803786 ad='6ec7c8a0'
delete from idl_char$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601667274
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=203,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601667606
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=121 op='INDEX RANGE SCAN I_IDL_CHAR1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601667892 hv=2040504303 ad='6ec77a48'
delete from idl_ub2$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=85,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601667883
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=209,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601668272
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=122 op='INDEX RANGE SCAN I_IDL_UB21 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601668554 hv=2589750466 ad='6ec78848'
delete from idl_sb4$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601668546
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30923
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=204,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601668877
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=123 op='INDEX RANGE SCAN I_IDL_SB41 '
=====================
PARSING IN CURSOR #13 len=32 dep=2 uid=0 oct=7 lid=0 tim=329601711966 hv=3105281081 ad='6ec723f0'
delete from error$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=42861,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601711951
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=1305,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601713504
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=125 op='INDEX RANGE SCAN I_ERROR1 '
=====================
PARSING IN CURSOR #13 len=40 dep=2 uid=0 oct=7 lid=0 tim=329601749728 hv=2746436814 ad='6ec699d0'
delete from procedureinfo$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=35907,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=329601749715
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24 offset=0
bfp=09b4b800 bln=22 avl=04 flg=05
value=30923
EXEC #13:c=0,e=652,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601750535
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=116 op='INDEX RANGE SCAN I_PROCEDUREINFO1 '
=====================
PARSE ERROR #13:len=36 dep=2 uid=0 oct=7 lid=0 tim=329601751272 err=942
delete from argument$ where obj#=:1
EXEC #9:c=46875,e=597553,p=0,cr=100,cu=0,mis=0,r=0,dep=1,og=4,tim=329601772145
ERROR #9:err=604 tim=32962970
FETCH #2:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=329601772955
=====================
PARSING IN CURSOR #9 len=38 dep=1 uid=0 oct=16 lid=0 tim=329601774331 hv=0 ad='9b4fc04'
drop sequence "ZYK"."MTG_LOG_SEQUENCE"
END OF STMT
PARSE #9:c=0,e=1232,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=329601774299
BINDS #9:
=====================
PARSING IN CURSOR #13 len=256 dep=2 uid=0 oct=47 lid=0 tim=329601774876 hv=3505430014 ad='6ed75cf8'
BEGIN
   /* NOP UNLESS A TABLE OBJECT */
   IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active >; 0
   THEN
      sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
   END IF;
   END;
END OF STMT
PARSE #13:c=0,e=202,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601774866
BINDS #13:
EXEC #13:c=0,e=212,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=329601775213
=====================
PARSING IN CURSOR #13 len=253 dep=2 uid=35 oct=47 lid=35 tim=329601775636 hv=801458082 ad='6ed6746c'
BEGIN
  IF (xdb.DBMS_XDBZ.is_hierarchy_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
  END IF;
  EXCEPTION
WHEN OTHERS THEN
   null;
END;
END OF STMT
PARSE #13:c=0,e=186,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601775625
BINDS #13:
BINDS #3:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=64 offset=0
bfp=09b4b708 bln=32 avl=03 flg=05
value="ZYK"
bind 1: dty=1 mxl=32(16) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=32
bfp=09b4b728 bln=32 avl=16 flg=01
value="MTG_LOG_SEQUENCE"
EXEC #3:c=0,e=536,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601776582
FETCH #3:c=0,e=1319,p=0,cr=33,cu=0,mis=0,r=1,dep=3,og=4,tim=329601777948
BINDS #4:
bind 0: dty=1 mxl=32(16) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=32 offset=0
bfp=09b4b728 bln=32 avl=16 flg=05
value="MTG_LOG_SEQUENCE"
EXEC #4:c=0,e=277,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601778531
FETCH #4:c=0,e=274,p=0,cr=9,cu=0,mis=0,r=1,dep=3,og=4,tim=329601778843
EXEC #13:c=0,e=3267,p=0,cr=42,cu=0,mis=0,r=1,dep=2,og=4,tim=329601779036
BINDS #10:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b548a4 bln=22 avl=02 flg=05
value=66
bind 1: dty=1 mxl=32(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b7fbf0 bln=32 avl=16 flg=05
value="MTG_LOG_SEQUENCE"
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b545a8 bln=24 avl=02 flg=05
value=1
bind 3: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b5457c bln=32 avl=00 flg=05
bind 4: (No oacdef for this bind)
bind 5: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b54550 bln=32 avl=00 flg=05
bind 6: (No oacdef for this bind)
bind 7: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=09b54524 bln=32 avl=00 flg=05
bind 8: (No oacdef for this bind)
EXEC #10:c=0,e=340,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601779825
FETCH #10:c=0,e=93,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=329601779971
BINDS #11:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b546d0 bln=22 avl=04 flg=05
value=30932
EXEC #11:c=0,e=129,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601780273
FETCH #11:c=0,e=44,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=329601780360
BINDS #11:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b546d0 bln=22 avl=04 flg=05
value=30932
EXEC #11:c=0,e=127,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601780691
FETCH #11:c=0,e=44,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=329601780778
=====================
PARSING IN CURSOR #13 len=310 dep=2 uid=0 oct=3 lid=0 tim=329601780995 hv=2644650677 ad='6ed7ce1c'
select o.owner#, u.name,       o.name,          o.namespace,       o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.subname  from dependency$ d, obj$ o, user$ u  where d.p_obj#=:1  and (d.p_timestamp=:2 or d.property=2)  and d.d_obj#=o.obj#  and o.owner#=u.user#  and decode(:3,0,0,o.type#)=:3
END OF STMT
PARSE #13:c=0,e=104,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601780985
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b533e0 bln=22 avl=04 flg=05
value=30932
bind 1: dty=12 mxl=07(07) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=8 offset=0
bfp=09b533cc bln=08 avl=07 flg=05
value="1/17/2003 16:47:16"
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b533a8 bln=24 avl=01 flg=05
value=0
bind 3: (No oacdef for this bind)
EXEC #13:c=0,e=229,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601781445
FETCH #13:c=0,e=53,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601781552
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  '
STAT #13 id=3 cnt=0 pid=2 pos=1 obj=96 op='TABLE ACCESS BY INDEX ROWID DEPENDENCY$ '
STAT #13 id=4 cnt=0 pid=3 pos=1 obj=128 op='INDEX RANGE SCAN I_DEPENDENCY2 '
STAT #13 id=5 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #13 id=6 cnt=0 pid=5 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
STAT #13 id=7 cnt=0 pid=1 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #13 id=8 cnt=0 pid=7 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #13 len=34 dep=2 uid=0 oct=7 lid=0 tim=329601782042 hv=440924843 ad='6eca5c38'
delete from context$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=91,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601782032
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=178,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601782353
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=432 op='INDEX UNIQUE SCAN I_CONTEXT '
=====================
PARSING IN CURSOR #13 len=30 dep=2 uid=0 oct=7 lid=0 tim=329601782637 hv=1539651961 ad='6eca078c'
delete from dir$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601782628
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=156,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601782909
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=124 op='INDEX UNIQUE SCAN I_DIR1 '
=====================
PARSING IN CURSOR #13 len=36 dep=2 uid=0 oct=7 lid=0 tim=329601783193 hv=1267976423 ad='6ec9ca34'
delete from type_misc$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601783184
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=170,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601783481
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=295 op='TABLE ACCESS CLUSTER TYPE_MISC$ '
STAT #13 id=3 cnt=0 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
=====================
PARSING IN CURSOR #13 len=34 dep=2 uid=0 oct=7 lid=0 tim=329601783780 hv=704812413 ad='6ec9c204'
delete from library$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601783772
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=487,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601784384
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=359 op='TABLE ACCESS CLUSTER LIBRARY$ '
STAT #13 id=3 cnt=0 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
=====================
PARSING IN CURSOR #13 len=36 dep=2 uid=0 oct=7 lid=0 tim=329601785304 hv=3410902463 ad='6eca44fc'
delete from procedure$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=645,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601785290
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=195,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601785710
=====================
PARSING IN CURSOR #14 len=35 dep=2 uid=0 oct=7 lid=0 tim=329601785901 hv=4035170006 ad='6ec98d4c'
delete from operator$ where obj#=:1
END OF STMT
PARSE #14:c=0,e=89,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601785892
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30932
EXEC #14:c=0,e=154,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601786185
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=370 op='INDEX UNIQUE SCAN OPER1 '
=====================
PARSING IN CURSOR #14 len=36 dep=2 uid=0 oct=7 lid=0 tim=329601786474 hv=829233079 ad='6ec8fefc'
delete from opbinding$ where obj#=:1
END OF STMT
PARSE #14:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601786465
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30932
EXEC #14:c=0,e=175,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601786767
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=372 op='INDEX RANGE SCAN OPBIND1 '
=====================
PARSING IN CURSOR #14 len=38 dep=2 uid=0 oct=7 lid=0 tim=329601787055 hv=35434631 ad='6ec8c0c8'
delete from opancillary$ where obj#=:1
END OF STMT
PARSE #14:c=0,e=87,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601787047
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30932
EXEC #14:c=0,e=169,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601787346
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=374 op='INDEX RANGE SCAN OPANC1 '
=====================
PARSING IN CURSOR #14 len=34 dep=2 uid=0 oct=7 lid=0 tim=329601787621 hv=2533305334 ad='6ec85838'
delete from oparg$ where obj# = :1
END OF STMT
PARSE #14:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601787613
BINDS #14:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b7ecc8 bln=22 avl=04 flg=05
value=30932
EXEC #14:c=0,e=205,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601787937
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #14 id=2 cnt=0 pid=1 pos=1 obj=376 op='INDEX RANGE SCAN OPARG1 '
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=159,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601788324
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=115 op='INDEX UNIQUE SCAN I_PROCEDURE1 '
=====================
PARSING IN CURSOR #13 len=33 dep=2 uid=0 oct=7 lid=0 tim=329601788662 hv=3605072212 ad='6ec81228'
delete from source$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=120,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601788651
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24 offset=0
bfp=09b4b700 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=267,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601789024
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=119 op='INDEX RANGE SCAN I_SOURCE1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601789385 hv=2986507294 ad='6ec7e560'
delete from idl_ub1$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601789376
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=261,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601789769
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=120 op='INDEX RANGE SCAN I_IDL_UB11 '
=====================
PARSING IN CURSOR #13 len=47 dep=2 uid=0 oct=7 lid=0 tim=329601790083 hv=3040803786 ad='6ec7c8a0'
delete from idl_char$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=81,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601790075
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=220,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601790427
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=121 op='INDEX RANGE SCAN I_IDL_CHAR1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601790709 hv=2040504303 ad='6ec77a48'
delete from idl_ub2$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601790700
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=232,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601791064
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=122 op='INDEX RANGE SCAN I_IDL_UB21 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601791353 hv=2589750466 ad='6ec78848'
delete from idl_sb4$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=79,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601791343
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=01 flg=05
value=0
EXEC #13:c=0,e=215,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601791691
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=123 op='INDEX RANGE SCAN I_IDL_SB41 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601792312 hv=2986507294 ad='6ec7e560'
delete from idl_ub1$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=93,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601792301
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=1016,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601793475
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=120 op='INDEX RANGE SCAN I_IDL_UB11 '
=====================
PARSING IN CURSOR #13 len=47 dep=2 uid=0 oct=7 lid=0 tim=329601793899 hv=3040803786 ad='6ec7c8a0'
delete from idl_char$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=101,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601793890
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=229,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601794266
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=121 op='INDEX RANGE SCAN I_IDL_CHAR1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601794557 hv=2040504303 ad='6ec77a48'
delete from idl_ub2$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=81,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601794548
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=479,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601795201
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=122 op='INDEX RANGE SCAN I_IDL_UB21 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601795517 hv=2589750466 ad='6ec78848'
delete from idl_sb4$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601795509
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=1
EXEC #13:c=0,e=222,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601795866
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=123 op='INDEX RANGE SCAN I_IDL_SB41 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601796169 hv=2986507294 ad='6ec7e560'
delete from idl_ub1$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=79,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601796160
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=199,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601796487
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=120 op='INDEX RANGE SCAN I_IDL_UB11 '
=====================
PARSING IN CURSOR #13 len=47 dep=2 uid=0 oct=7 lid=0 tim=329601796774 hv=3040803786 ad='6ec7c8a0'
delete from idl_char$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=88,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601796764
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=200,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601797095
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=121 op='INDEX RANGE SCAN I_IDL_CHAR1 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601797373 hv=2040504303 ad='6ec77a48'
delete from idl_ub2$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601797365
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=200,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601797693
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=122 op='INDEX RANGE SCAN I_IDL_UB21 '
=====================
PARSING IN CURSOR #13 len=46 dep=2 uid=0 oct=7 lid=0 tim=329601797982 hv=2589750466 ad='6ec78848'
delete from idl_sb4$ where obj#=:1 and part=:2
END OF STMT
PARSE #13:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601797973
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b53470 bln=22 avl=04 flg=05
value=30932
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b5344c bln=24 avl=02 flg=05
value=2
EXEC #13:c=0,e=236,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601798336
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=123 op='INDEX RANGE SCAN I_IDL_SB41 '
=====================
PARSING IN CURSOR #13 len=32 dep=2 uid=0 oct=7 lid=0 tim=329601798636 hv=3105281081 ad='6ec723f0'
delete from error$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601798627
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b534b8 bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=185,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=329601799011
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=125 op='INDEX RANGE SCAN I_ERROR1 '
=====================
PARSING IN CURSOR #13 len=40 dep=2 uid=0 oct=7 lid=0 tim=329601799370 hv=2746436814 ad='6ec699d0'
delete from procedureinfo$ where obj#=:1
END OF STMT
PARSE #13:c=0,e=125,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601799360
BINDS #13:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24 offset=0
bfp=09b4466c bln=22 avl=04 flg=05
value=30932
EXEC #13:c=0,e=208,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=329601799672
STAT #13 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #13 id=2 cnt=0 pid=1 pos=1 obj=116 op='INDEX RANGE SCAN I_PROCEDUREINFO1 '
=====================
PARSE ERROR #13:len=36 dep=2 uid=0 oct=7 lid=0 tim=329601800316 err=942
delete from argument$ where obj#=:1
EXEC #9:c=31250,e=28901,p=0,cr=94,cu=0,mis=0,r=0,dep=1,og=4,tim=329601803335
ERROR #9:err=604 tim=32962973
FETCH #2:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=329601803669
=====================
PARSING IN CURSOR #9 len=39 dep=1 uid=0 oct=16 lid=0 tim=329601804008 hv=0 ad='9b4fc04'
drop sequence "ZYK"."MTG_OUID_SEQUENCE"
END OF STMT
PARSE #9:c=0,e=227,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=329601803997
BINDS #9:
=====================
PARSING IN CURSOR #13 len=256 dep=2 uid=0 oct=47 lid=0 tim=329601804441 hv=3505430014 ad='6ed75cf8'
BEGIN
   /* NOP UNLESS A TABLE OBJECT */
   IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active >; 0
   THEN
      sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
   END IF;
   END;
END OF STMT
PARSE #13:c=0,e=187,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601804431
BINDS #13:
EXEC #13:c=0,e=214,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=329601804789
=====================
PARSING IN CURSOR #13 len=253 dep=2 uid=35 oct=47 lid=35 tim=329601805201 hv=801458082 ad='6ed6746c'
BEGIN
  IF (xdb.DBMS_XDBZ.is_hierarchy_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
  END IF;
  EXCEPTION
WHEN OTHERS THEN
   null;
END;
END OF STMT
PARSE #13:c=0,e=187,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=329601805192
BINDS #13:
BINDS #3:
bind 0: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=64 offset=0
bfp=09b4b708 bln=32 avl=03 flg=05
value="ZYK"
bind 1: dty=1 mxl=32(17) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=32
bfp=09b4b728 bln=32 avl=17 flg=01
value="MTG_OUID_SEQUENCE"
EXEC #3:c=0,e=538,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601806472
FETCH #3:c=0,e=782,p=0,cr=33,cu=0,mis=0,r=1,dep=3,og=4,tim=329601807923
BINDS #4:
bind 0: dty=1 mxl=32(17) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=32 offset=0
bfp=09b4b728 bln=32 avl=17 flg=05
value="MTG_OUID_SEQUENCE"
EXEC #4:c=0,e=280,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=329601808480
FETCH #4:c=0,e=848,p=0,cr=9,cu=0,mis=0,r=1,dep=3,og=4,tim=329601809370
EXEC #13:c=0,e=4267,p=0,cr=42,cu=0,mis=0,r=1,dep=2,og=4,tim=329601809602
BINDS #10:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=09b548a4

文库|博客

yikaikai

富足长乐

论坛徽章:: 0

2楼 [报告]

发表于 2003-01-29 11:35 |只看该作者

用户删不掉，新添加的可以，这是trace文件

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 29 11:36:28 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL>; connect / as sysdba
Connected.
SQL>; drop user zyk cascade;
drop user zyk cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

gototop

丰衣足食

论坛徽章:: 0

3楼 [报告]

发表于 2003-01-29 12:44 |只看该作者

用户删不掉，新添加的可以，这是trace文件

好像是个bug哦，你metalink上看看吧

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

sql2000

小富即安

论坛徽章:: 0

4楼 [报告]

发表于 2003-01-29 13:23 |只看该作者

用户删不掉，新添加的可以，这是trace文件

可能是你的数据字典有些问题，在数据字典里有的用户表或视图信息被破坏了。

select TABLE_NAME from all_tables where owner='zyk';
select TABLE_NAME from all_views where owner='zyk';

你先单独删除这些表和视图，再删除用户。