OGG Tuning 所需注意的tips

Split the Process Using GoldenGate Range Function
http://www.vitalsofttech.com/goldengate-range-function/


Tuning GoldenGate Extract Pump performance
1.These parameters can be used like following:

rmthost, mgrport, compress, tcpbufsize 10000, tcpflushbytes 10000

2.
Use PASSTHRU --> Only send tables needed

http://t.askmaclean.com/thread-3574-1-1.html

3.針對特定表格 可以指定SCN重新匯資料  http://chandu208.blogspot.tw/2014/01/how-to-add-new-tables-for-running-ogg.html
3.1 SQL> select current_scn from v$database;

CURRENT_SCN
------------------------
5343407

3.2 Check that there are no open DML transactions against the table. If there are open transactions, make sure that their starting SCN is higher than the one obtained in step 4) , i.e. 5343407

3.3 re-sync the the newly added table from source to target(using normal export/import).
Make sure to use FLASHBACK_SCN parameter for the export.

3.4 Add the table in the replicat parameter file including the below option( FILTER ( @GETENV ("TRANSACTION", "CSN") > ) )as shown in the below example
eg:-
MAP source.test1, TARGET target.test1 ,FILTER ( @GETENV ("TRANSACTION", "CSN") > 5343407);
MAP source.test2, TARGET target.test2 ,FILTER ( @GETENV ("TRANSACTION", "CSN") > 5343407);

3.5 start the replicat

3.6 verify the tables on source and table and once the lag is zero remove the filter parameter from the replicat parameter file and restart.

4. GoldenGate Performance Tuning, Configuration Attributes & Monitoring (Doc ID 1455566.1)
Improving Datapump performance
  Use the PASSTHRU parameter to stop the Extract process looking up table definitions from the database or from a data-definitions file

Splitting large transactions

MAXTRANSOPS
MAXSQLSTATEMENTS

5.
extract ext1
CACHEMGR CACHESIZE 8G

6.
LOBMEMORY enables you to tune GoldenGate's cache size for LOB

7.OGG 11g/ 12c : DBOPTIONS for delete cascade fk , triggers
SUPPRESSTRIGGERS
SUPPRESSTRIGGERS is the default and prevents triggers from firing on target objects that are configured for replication with Oracle GoldenGate. SUPPRESSTRIGGERS is valid for Oracle 11.2.0.2 and later 11gR2 versions. SUPPRESSTRIGGERS is not valid for 11gR1.

DEFERREFCONST
Valid for nonintegrated Replicat for Oracle. Sets constraints to DEFERRABLE to delay the checking and enforcement of cascade delete and cascade update referential integrity constraints by the Oracle target database until the Replicat transaction is committed. At that point, if there are constraint violations, an error is generated. Integrated Replicat does not require disabling of referential constraints on the target system.

8.To split large source transactions into smaller ones on the target system.
MAXTRANSOPS