Home » RDBMS Server » Networking and Gateways » Re: ORA-02042: too many distributed transactions while using database link
- Re: ORA-02042: too many distributed transactions while using database link [message #66169] Mon, 07 January 2002 23:49 Go to next message
Ewoks
Messages: 1
Registered: January 2002
Junior Member
Increase the DISTRIBUTED_TRANSACTIONS parameter in the initialization parameter file, shut down and restart Oracle, or run fewer transactions. If it is certain there are not too many concurrent distributed transactions, this may be an internal error. In this case, contact customer support. Shutting down and restarting the instance could be a work-around.

Report message to a moderator

- Re: ORA-02042: too many distributed transactions while using database link [message #66753 is a reply to message #66169] Wed, 11 December 2002 18:39 Go to previous message
amelia
Messages: 2
Registered: December 2002
Junior Member
Hi, I am not very tech savvy but I need to solve a problem for my customer.

How do I ascertain that there are not too many concurrent distributed transactions? Is there an SQL query I can use?

And wouldn't shutting down Oracle disable the system for quite a while?

Thanks.

Report message to a moderator

Previous Topic: Re: Can't Install java 2 on Pentium 4 ?
Next Topic: NAMES SERVER MIGRATION
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 01 16:06:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.