Re: How to delete in-doubt transactions

From: Danut Bancea <danut_at_telepages.ca>
Date: Fri, 12 May 2000 11:18:17 -0400
Message-Id: <10495.105520@fatcity.com>

Sorry for so late answer.

You can delete a in-doubt ranscation using the package DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('trans_id').

You can see which transcation are in-doubt using next select statement:

select * from dba_2pc_pending;

or relation with remote database

select * from dba_2pc_neighbors

Also you can find more in information in Oracle8i Supplied PL/SQL Packages Reference at dbms_transcation package.

Version of the database is 8.1.6

Danut,

---

Danut Bancea
Senior Oracle DBA

Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca

---

• Original Message ----- From: <cyhu_at_eachnet.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, April 28, 2000 2:32 AM Subject: How to delete in-doubt transactions

> 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.747578320000000000000000000000000000000000000000000000000000000016B907004

409F938128E9100
> 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.747578320000000000000000000000000000000000000000000000000000000016B907004

409F938128E9100
> 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_at_eachnet.com
> ===========================
>
>
> --
> 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
Received on Fri May 12 2000 - 10:18:17 CDT