What is transaction guard? Transaction guard supported and unsupported transactions.
meda Changed status to publish 15/07/2022
Transaction guard is an oracle database feature introduced on oracle 12C and it enables the continuity of applications after database outages. It is an API that returns the outcomes of the last transaction after a recoverable error has occurred. And it is part of both standard and flex RAC cluster database configurations.
Transaction guard returns the outcome of the last transaction after a recoverable error using Logical Transaction ID(LTXID) and is used by Application continuity.
Transaction guard supported transactions:
- Local Transactions
- Parallel Transactions
- Distributed & Remote Transactions
- DDL & DCL Transactions
- Auto-commit and commit-on success
- PL/SQL with embedded Commit
Transaction guard unsupported transactions:
- Recursive transactions
- Autonomous transactions
- Active Data Guard with read/write DB links for forwarding transactions
- Golden Gate & Logical Standby
Ezana Answered question 09/07/2022