Message-Id: <10481.104451@fatcity.com> From: "Rubeck, Pat" Date: Fri, 28 Apr 2000 10:56:02 -0500 Subject: RE: How to delete in-doubt transactions I had a similiar problem a few years ago. I got an ORA-01591 "lock held = by in-doubt distributed transaction nnn" To fix this match the transaction number in the message with the GLOBAL_TRAN_ID in DBA_2PC_PENDING table and either rollback or commit = the transaction. ROLLBACK FORCE '6.7.43497' ; or COMMIT FORCE '6.7.43497'; > -----Original Message----- > From: cyhu@eachnet.com [SMTP:cyhu@eachnet.com] > Sent: Friday, April 28, 2000 1:33 AM > To: Multiple recipients of list ORACLE-L > Subject: How to delete in-doubt transactions >=20 > I found a in-doute transaction through Instance Manager. The = application > could not query a table which was dead-locked by this in-doubt > transaction. > I knew nothing to clear this. I had to shutdown the instance. After = that, > everything is ok.Below is part of trace file. >=20 > *** SESSION ID:(8.6) 2000.04.28.09.58.22.000 > DISTRIB TRAN > = 28.747578320000000000000000000000000000000000000000000000000000000016B90= 70 > 04409F938128E9100 > is local tran 6.7.43497 (hex=3D06.07.a9e9) > change pending prepared tran, scn=3D9377247 (hex=3D0.008f15df) > to pending collecting tran, scn=3D9377247 (hex=3D0.008f15df) > DISTRIB TRAN > = 28.747578320000000000000000000000000000000000000000000000000000000016B90= 70 > 04409F938128E9100 > is local tran 6.7.43497 (hex=3D06.07.a9e9)) > delete pending collecting tran, scn=3D9377247 (hex=3D0.008f15df) >=20 > Thank in advance. > =BA=FA=B4=BA=D3=EA > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D > Tel:(8621)52340871/0872*667 > E-mail:cyhu@eachnet.com > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D > =02=EBa=A2=B2 > = =1172=86=E7=9Ar=19=DE=B5=CA&=15=ABB=8A=DC=8Dz=DC(=AED=9E=AE=F8=9Cz=CF9=F3= =9D=FC=E7Nu=14=05=FC=E7=CEw=F3=9D9=D5&=A7=0E'=A0=A0&=A5=89=FA+=9E&=8F=B9= =B9bp=89=EDz=B9=DE=B5=A7=1Cz > =CB?1=A8=A5=8Ax > = =8A=CBlN=84D0=E5D=CA=8B=AB=B1=E9_~=BA&=B6=18=AC=99=A8=A5=8Ax%=8A=CBlzwZ=9C= C=1A=8AY=9E=B2=C6=A0z=DA=0B=8A=CBF=BA=BB=9Fj=D7"=B7'(=9Az-xE=C0 ;)zYb? > = =1F.+-=1A=EA=EEjwb=9E=D8^=99=EB,j=07=8186"=9D=C9nu=E6=A5=8Aw=9C=A2{Z=8Ax=