| Locks on v$global_transaction [message #53648] |
Thu, 03 October 2002 05:12  |
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?
|
|
|
|
| Re: Locks on v$global_transaction [message #53677 is a reply to message #53648] |
Fri, 04 October 2002 11:53  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
