Re: Question on in-doubt transaction

From: David Davis <davisdav_at_hotmail.com>
Date: Mon, 04 Nov 2002 18:58:23 -0800
Message-ID: <F001.004FB7EE.20021104185823@fatcity.com>

Check out the documentation for the dbms_transaction package. I have used it previously (dbms_transaction.purge_lost_db_entry). In my case, the cause was due to a problem in SQL Server (DTS process).

See Docids on Metalink:

67590.1 - PROCEDURE:DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY 100664.1 - How to Troubleshoot Distributed Transactions

Good Luck.

>From: "Mandal, Ashoke" <ashoke.k.mandal_at_medtronic.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Question on in-doubt transaction
>Date: Mon, 04 Nov 2002 09:54:14 -0800
>
>Greetings All,
>
>We have a stand alone database on a Windows-NT box. As far as I understand
>from the users of this database that this is not in distributed
>environment.
>
>But there is one in-doubt transaction in this database and if users try to
>work in this database the response is very slow due to this in-doubt
>transaction.
>
>We bounced the database. Restarted the service but in-doubt transaction is
>still sitting there from Feb 2002.
>
>We could see this transaction in DBA Studio also.
>
>How to clean this transaction?
>
>Thanks,
>Ashoke
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mandal, Ashoke
> INET: ashoke.k.mandal_at_medtronic.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

---

Choose an Internet access plan right for you -- try MSN! http://resourcecenter.msn.com/access/plans/default.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Davis
  INET: davisdav_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Mon Nov 04 2002 - 20:58:23 CST