Book Image

Oracle GoldenGate 12c Implementer's Guide

Book Image

Oracle GoldenGate 12c Implementer's Guide

Overview of this book

Table of Contents (21 chapters)
Oracle GoldenGate 12c Implementer's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
GGSCI Commands
GoldenGate Installed Components
Acronyms
Index

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