Oracle Triggers Agent
Introduction
The Oracle Triggers agent provides Change Data Capture through a robust auditing structure based on database triggers. This approach offers a reliable way to track changes across your Oracle database tables without requiring complex transaction log configurations.
Key Features
-
Trigger-based auditing system
-
Atomic sequence tracking for row-level changes
-
Minimal setup requirements
-
Compatible with older Oracle versions, any edition
-
Built-in JDBC driver connection
How It Works
The Triggers agent tracks record changes using:
-
Database triggers that monitor INSERT, UPDATE, and DELETE operations after commit, in transaction with in-memory buffered rows;
-
A dedicated CDC table that stores:
-
Unique row identifiers for changed records;
-
CRUD action types;
-
Minimal metadata thanks to the change tracking technique.
-
Tecnology under the hood
The triggers business logic that powers the Oracle Triggers agent is based on a per-transaction logic, and only tracks changed row IDs, storing data on a table called CDC where all changed row IDs are stored and their data type is maintained unaltered.
The CDC table is populated by the triggers and managed by the agent.
Supported Versions
The Oracle Triggers agent works on:
-
Any Oracle Database version from 11.2g onwards
-
Both single-tenant and multi-tenant architectures
-
No specific database edition requirements