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.