Comparison Between Oracle Streams and GoldenGate

Staging Streams: Streams may store or stage changes in a database buffered queue. The benefit is that changes are stored in memory which has a fast access time. GoldenGate: When processing a one-time activity : an initial load or a batch run, GoldenGate stages extracted changes in an extract file. During normal operation , GoldenGate … Read more

Before we start tuning GoldenGate…

Large objects (LOBs) LOBs can be a problem in data replication by virtue of their size and the ability to extract, transmit, and deliver the data from source to target. Tables containing LOB datatypes should be isolated from regular data to use a dedicated Extract, Data Pump, and Replicat process group to enhance throughput. It … Read more

Adding Replicats with @RANGE function in GG

Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly, we opted in creating Range Replicat. The RANGE function The way the @RANGE function works is it computes a hash value of the columns specified in the input. If no columns are specified, it uses … Read more

GGSCI Command for GoldenGate

INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER This command also display the info of manager REFRESH REFRESH MANAGER Reloads from the Manager Parameter file REFRESH MGR Reloads from the Manager Parameter file SEND SEND MANAGER CHILDSTATUS Displays status of processes, started by … Read more