===================== PARSING IN CURSOR #18135904 lid=0 tim=302295369306 hv=3667723989 ad='7ffda7f5b500' sqlid='2mp99nzd9u1qp' delete from histgrm$ where obj # = :1 END OF STMT PARSE #18135904:c=0,e=1191,p=0,cr=44,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=302295369306 BINDS #16769312: Bind #0 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0 kxsbbbfp=01144048 bln=22 avl=02 flg=05 value=66 Bind #1 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24 kxsbbbfp=01144060 bln=22 avl=02 flg=01 value=1 EXEC #16769312:c=0,e=85,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=302295369571 FETCH #16769312:c=0,e=7,p=0,cr=4,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=302295369592 CLOSE #16769312:c=0,e=4,dep=2,type=3,tim=302295369610 BINDS #16769312: Bind #0 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0 kxsbbbfp=01144048 bln=22 avl=02 flg=05 value=66 Bind #1 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24 kxsbbbfp=01144060 bln=22 avl=02 flg=01 value=2 EXEC #16769312:c=0,e=79,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=302295369724 FETCH #16769312:c=0,e=6,p=0,cr=4,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=302295369740 CLOSE #16769312:c=0,e=4,dep=2,type=3,tim=302295369756 BINDS #18135904: Bind #0 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0 kxsbbbfp=01145078 bln=22 avl=06 flg=05 value=4294951147 WAIT #18135904: nam='db file sequential read' ela= 127 file#=1 block#=609 blocks=1 obj#=67 tim=302295370065 WAIT #18135904: nam='db file sequential read' ela= 188 file#=1 block#=243448 blocks=1 obj#=67 tim=302295370285 Dumping Short Stack ksedsts()+314<-kcbzib()+17818<-kcbgtcr()+12688<-ktrgtc2()+802<-qeilbk1()+7661<-qeilsr()+185<-qerixtFetch() ………… <-opidrv()+848<-sou2o()+94<-opimai_real()+281<-opimai()+170<-00007FFC2EAC7374<-00007FFC2FADCC91 kcbzib: dump suspect buffer, err2=8103 Encrypted block <0, 4437752> content will not be dumped. Dumping header only. buffer tsn: 0 rdba: 0x0043b6f8 (1 /243448 ) scn: 0x0.0 seq : 0x01 flg: 0x05 tail : 0x00000001 frmt: 0x02 chkval: 0x11bb type : 0x00=unknown Dump of buffer cache at level 8 for pdb=0 tsn=0 rdba=4437752 BH (0x7ffd55f95998) file #: 1 rdba: 0x0043b6f8 (1/243448) class: 1 ba: 0x7ffd5555e000 set : 50 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 0,0 dbwrid: 1 obj: 67 objn: 67 tsn: [0 /0 ] afn: 1 hint: f hash : [0x7ffdaca1f3a0,0x7ffdaca1f3a0] lru: [0x7ffd55f95bc0,0x7ffda9328448] ckptq: [NULL] fileq: [NULL] objq: [0x7ffd9d61a3c0,0x7ffd9d61a3c0] objaq: [0x7ffd9d61a3b0,0x7ffd9d61a3b0] use: [0x7ffdaaf604f8,0x7ffdaaf604f8] wait: [NULL] st: READING md: EXCL tch: 0 flags: only_sequential_access Using State Objects ---------------------------------------- SO: 0x00007FFDAAF60470, type : 46, owner: 0x00007FFD9B3C5ED8, flag: INIT /-/-/0x00 if : 0x1 c: 0x1 proc=0x00007FFDAB2984C0, name=buffer handle, file =kcb2.h LINE:3317, pg=0 conuid=0 (buffer) (CR) PR: 0x00007FFDAB2984C0 FLG: 0x0 SEQ: 0x439 class bit: 0x0 scan scn: 0.0 cr[0]: sh[0]: kcbbfbp: [BH: 0x00007FFD55F95998, LINK: 0x00007FFDAAF604F8] type : normal pin where: qeilwhnp: qeilbk, why: 0 EXEC #18135904:c=234375,e=235311,p=2,cr=9,cu=0,mis=1,r=0,dep=1,og=4,plh=2015116224,tim=302295604662 ERROR #18135904:err=8103 tim=302295604678 STAT #18135904 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE HISTGRM$ (cr=0 pr=0 pw=0 time=2 us)' STAT #18135904 id=2 obj=67 op='INDEX RANGE SCAN I_H_OBJ#_COL# (cr=0 pr=0 pw=0 time=0 us cost=3 size=376 card=47)' ORA-00604: 递归 SQL 级别 1 出现错误 ORA-08103: 对象不再存在 ORA-00604: 递归 SQL 级别 1 出现错误 ORA-08103: 对象不再存在 *** 2024-07-15 10:53:30.201 USER (ospid: 39348): terminating the instance due to error 604 |