Oracle GoldenGate Tools – ShowSyntax and logdump

GoldenGate Self-Help Tools include

  • Knowledge Documents (Maintained by experts and accessible from My Oracle Support
  • Documentation (Configuration instructions and descriptions of Oracle GoldenGate errors, commands, parameters, and functions
  • ShowSyntax parameter (Shows Replicat SQL statements)
  • logdump utility (Tool for viewing and analyzing Oracle GoldenGate trails)
  • Trace and TLTrace parameters (Debugging feature to detect bottlenecks)
  • Oracle GoldenGate Veridata (High-Speed solution to compare tables

ShowSyntax Parameter

  • With this parameter, Replicat displays SQL DML statements before executing them.
  • ShowSyntax helps you diagnose failed operations such as the following:
    – The WHERE clause may be using a non-indexed column
    – A row may be locked by another process
    – There may be no value for the SET clause

ShowSyntax Parameter : Usage

  • Parameters that must be used with ShowSyntax: NoDynSQL and NoBinaryChars
    Note: Each must be on a line by itself, before ShowSyntax.
  • Start Replicat from the command shell in the home directory.
  • Do not specify a report file. The output must go to screen.
  • In Oracle GoldenGate 12c, ShowSyntax now works with dynamic SQL.

logdump Utility: Overview

  • With logdump, you can:
    * Search for, filter, view, and save data that is stored in an Oracle GoldenGate trail or extract file
    * Save part of a trail to another trail file
    * Edit and reuse a history of numbered logdump command lines

Note: Use logdump only if you need to view data in the Oracle GoldenGate trail files.

Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Notify of
Inline Feedbacks
View all comments