Re: Question on in-doubt transaction

2002-11-04 Thread David Davis 
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" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Question on in-doubt transaction

2002-11-04 Thread Mandal, Ashoke 
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).