Message-Id: <10481.104430@fatcity.com> From: Chuck Hamilton Date: Fri, 28 Apr 2000 07:31:35 -0700 (PDT) Subject: Re: How to delete in-doubt transactions --0-1365180540-956932295=:9451 Content-Type: text/plain; charset=us-ascii Try "rollback '6.7.43497' force". cyhu@eachnet.com wrote: 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. *** SESSION ID:(8.6) 2000.04.28.09.58.22.000 DISTRIB TRAN 28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100 is local tran 6.7.43497 (hex=06.07.a9e9) change pending prepared tran, scn=9377247 (hex=0.008f15df) to pending collecting tran, scn=9377247 (hex=0.008f15df) DISTRIB TRAN 28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100 is local tran 6.7.43497 (hex=06.07.a9e9)) delete pending collecting tran, scn=9377247 (hex=0.008f15df) Thank in advance. =========================== Tel:(8621)52340871/0872*667 E-mail:cyhu@eachnet.com =========================== -- Author: INET: cyhu@eachnet.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --------------------------------- Do You Yahoo!? Talk to your friends online and get email alerts with Yahoo! Messenger. --0-1365180540-956932295=:9451 Content-Type: text/html; charset=us-ascii

Try  "rollback '6.7.43497' force".

cyhu@eachnet.com wrote:

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.

*** SESSION ID:(8.6) 2000.04.28.09.58.22.000
DISTRIB TRAN
28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100
is local tran 6.7.43497 (hex=06.07.a9e9)
change pending prepared tran, scn=9377247 (hex=0.008f15df)
to pending collecting tran, scn=9377247 (hex=0.008f15df)
DISTRIB TRAN
28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100
is local tran 6.7.43497 (hex=06.07.a9e9))
delete pending collecting tran, scn=9377247 (hex=0.008f15df)

Thank in advance.

===========================
Tel:(8621)523! 40871/0872*667
E-mail:cyhu@eachnet.com
===========================


--
Author:
INET: cyhu@eachnet.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger.