Oracle-L: Debugging ORA-2042 error

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Fri, 06 Dec 2002 04:28:39 -0800
Message-ID: <F001.005142D5.20021206042839@fatcity.com>

Dear Listers,

Oracle 8.1.7 on HP-UX11

We have three databases, one master and two slaves. On the slaves resides a view which queries data from master using a database link.

While querying from the view, we often get the error 'ORA-02042: too many distributed transactions'.

We are pretty sure that the error is raised on slaves and not on the master.

I found out that the 'distributed_transactions' parameter is set to a very low value, which is causing this error in the first place. But due to various reasons, this will not be possible soon.

The only thing I can think of is to have a list of all the distributed transactions, check which ones can be killed and kill them.

I tried the dba_2pc_pending table, but it doesn't have any records; still I am getting the ORA-02042 error.

Which are the views that would give me more information about the distributed transactions?

I would really appreciate if you can point out some document or article which treats this in detail.

Thanks & regards,
Charu

PS: How to check the archives of this list? I logged on to www.orafaq.com and searched on 'ORA-02042', without any good hits. I have lost the mail received at the time of joining the list.

Disclaimer

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

Visit us at http://www.mahindrabt.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Charu Joshi
INET: joshic_at_mahindrabt.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 Fri Dec 06 2002 - 06:28:39 CST