How to Use Transactions in Request Processing to Improve Database Performance
(Doc ID 1038076.1)
Last updated on JUNE 15, 2017
Oracle Commerce Platform - Version 2006.3 and later
Information in this document applies to any platform.
This article describes how to wrap request processing in transactions to improve database performance. This may be necessary if you encounter one of the following symptoms:
- High database CPU usage on Oracle due to latch free waits and enqueues with XA. Latch free waits are described in <Document 34576.1>.
- 10x latency increase with XA on MS SQL Server
Oracle ATG 9.0 and later versions require using XA database drivers.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.