Viewing integrated parameters

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...