Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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.
Thank in advance.
-- Author: INET: cyhu_at_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_at_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-asciiReceived on Fri Apr 28 2000 - 09:31:35 CDT
<P>Try "rollback '6.7.43497' force".</P>
<P><B><I>cyhu_at_eachnet.com</B></I> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">I found a in-doute transaction through Instance Manager. The application<BR>could not query a table which was dead-locked by this in-doubt transaction.<BR>I knew nothing to clear this. I had to shutdown the instance. After that,<BR>everything is ok.Below is part of trace file.<BR><BR>*** SESSION ID:(8.6) 2000.04.28.09.58.22.000<BR>DISTRIB TRAN<BR>28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100<BR>is local tran 6.7.43497 (hex=06.07.a9e9)<BR>change pending prepared tran, scn=9377247 (hex=0.008f15df)<BR>to pending collecting tran, scn=9377247 (hex=0.008f15df)<BR>DISTRIB TRAN<BR>28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100<BR>is local tran 6.7.43497 (hex=06.07.a9e9))<BR>delete pending collecting tran, scn=9377247 (hex=0.008f15df)<BR><BR>Thank in advance.<BR><BR>===========================<BR>Tel:(8621)523!
40871/0872*667<BR>E-mail:cyhu_at_eachnet.com<BR>===========================<BR><BR><BR>-- <BR>Author: <BR>INET: cyhu_at_eachnet.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br> Talk to your friends online and get email alerts with Yahoo! Messenger.
![]() |
![]() |