Forum Stats

  • 3,770,291 Users
  • 2,253,091 Discussions
  • 7,875,393 Comments

Discussions

Is the OracleMTSRecoveryService needed?

meridium
meridium Member Posts: 5

I have a C#.Net app using v12.1 ODP.Net Managed provider and Oracle Server 12.1.  In some cases my transactions involve multiple connections.  If so, all connections are to the same schema/database.  According to this document: http://docs.oracle.com/database/121/NTMTS/using.htm#NTMTS109

Oracle marks a multi-connection transaction as promotable, but not necessarily distributed.  It will not be promoted to a distributed transaction unless more than one database is involved.  If my transactions are never promoted to distributed, then do I need an Oracle MTS Recovery Service?  If all of my connections are to one database will I ever have an in-doubt transaction that this service would need to clean up?  My testing indicates the answer is no to both questions, but confirmation from Oracle would be nice.  Thanks.


Answers

This discussion has been closed.