Question: What is the purpose of
the file ggs_ddl_trace.log? It appears to be related
Answer: The ggs_ddl_trace.log
file is for Goldengate trace information and resides in the
user_dump_dest location. As the name implies
the ggs_ddl_trace.log file also contains DDL
The amount of DDL tracing is specified by the "value"
column of the ggs_setup table in Oracle.
The values are 0.1 and 2, with the default of 0.
Oracle says to only change this to a 1 or 2 value at the
direction of MOSC:
To modify the trace level, Oracle Goldengate
provides a ddl_tracelevel.sql script.