公开(公告)号：US20250094294A1

公开(公告)日：2025-03-20

申请号：US18884628

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Natesh Kedlaya ,  Sukhada Pendse ,  Ajit Mylavarapu ,  Tirthankar Lahiri ,  Carol Lyndall Colrain ,  Xiaoli Qi ,  Juan R. Loaiza

IPC: G06F11/14 ,  G06F16/23

Abstract: Techniques are described for Transaction Guard to impose at-most-once execution by generating and using the database's native transaction identifier, DB XID. In an implementation, DB XID is unique within a (pluggable) database instance (with local undo) and uniquely identifies a transaction in the database. The Transaction Guard that is extended to use native transaction information determines the commit outcome using the native transaction identifier of the transaction instead of relying on the persistence of the Logical Transaction Identifier (LTXID) in a separate table. Using the native transaction identifier, the Transaction Guard significantly improves performance by eliminating the extra write(s) incurred during commit operations.