Home » RDBMS Server » Server Administration » Locks on v$global_transaction
Locks on v$global_transaction [message #53648] Thu, 03 October 2002 05:12 Go to next message
Fernando M. Garcia
Messages: 1
Registered: October 2002
Junior Member
We have an application that uses Microsoft MTS for Oracle. When you start the application it queries the V$GLOBAL_TRANSACTION that sometimes is locked so the application doesn't start.

Could anybody tell me why Oracle locks this view?

Report message to a moderator

Re: Locks on v$global_transaction [message #53677 is a reply to message #53648] Fri, 04 October 2002 11:53 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
It shouldn't lock it. Are you sure that is the problem. If it is then maybe the application needs to set the transaction read only before it queries which is of course their problem not yours. I would ask them why it is happening.

Report message to a moderator

Previous Topic: Dropping Core
Next Topic: Re-creating Indexes and Query Performance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 00:58:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.