The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 28, 2026
Filed:
Sep. 13, 2024
Oracle International Corporation, Redwood Shores, CA (US);
Natesh Kedlaya, Redwood City, CA (US);
Sukhada Pendse, Foster City, CA (US);
Ajit Mylavarapu, Mountain View, CA (US);
Tirthankar Lahiri, Palo Alto, CA (US);
Carol Lyndall Colrain, Kansas City, KS (US);
Xiaoli Qi, Palo Alto, CA (US);
Juan R. Loaiza, Woodside, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.