Integrated capture was first introduced in Oracle GoldenGate 11g Release 2. Now, in 12c, Oracle offers the Integrated Replicat as a new feature. In the previous section, we discussed a number of performance tuning tips, including how to adjust GoldenGate's integrated parameters. There are many of these including underscore (hidden) parameters that should only be adjusted under guidance from Oracle support.
To view the current configuration in your GoldenGate enterprise, it is possible to query the Oracle Streams table (streams$_process_param) on both source and target databases, as shown in the following code:
SQL> col NAME format a35 SQL> col VALUE format a10 SQL> select decode(process_type,1,'APPLY',2,'CAPTURE') process_name, 2 name, value 3 from sys.streams$_process_params 4 order by 1,2; PROCESS NAME VALUE ------- ----------------------------------- ---------- APPLY ALLOW_DUPLICATE_ROWS N...
