How to Use Transactions in Request Processing to Improve Database Performance
(Doc ID 1038076.1)
Last updated on SEPTEMBER 07, 2023
Applies to:
Oracle Commerce Platform - Version 2006.3 and later Information in this document applies to any platform.
Goal
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.
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
