Oracle GoldenGate suppresstriggers
For replication involving Oracle GoldenGate, a
suppresstriggers option has been added to the dboptions
Replicat parameter. The purpose of the suppresstriggers
option is simply to prevent triggers from firing on objects targeted
For specific versions of Oracle using Oracle GoldenGate version
11.1 and higher, the suppresstriggers option relieves the
DBA of having to manually disable triggers and constraints
Replicat will disable triggers during its session with the
suppresstriggers option for the following Oracle versions:
- Oracle 10g R2 releases 10.2.0.5 and later patches
- Oracle 11g R2 releases 220.127.116.11 and higher
It is important to note that the suppresstriggers option
is NOT available in Oracle 11g R1.
The default setting for suppresstriggers is OFF or
Using the suppresstriggers option requires that the
Replicat user be an Oracle Streams administrator. The
following version-specific grants must be invoked:
- Oracle 10.2.0.5 and later patches:
- Oracle 18.104.22.168 and higher
If suppresstriggers is not working for you, verify that
you are using Oracle GoldenGate 11.1 or higher and are not using
Oracle 11g R1 database.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.