- For the number of bytes, you can refer to the following Oracle Support Note: 1356524.1 How to estimate GoldenGate extract redo processing speed? This an example calculated based on number of bytes of Oracle DB redo logs processed by GoldenGate.
- For the number of operations, you can use the GGSCI stats extract <group_name> command. In Oracle GoldenGate 12.3, you can use the REST API: /services/{version}/mpoints/{item}/statisticsExtract.
Oracle GoldenGate extract throughput can be represented in either the number of SQL operations or the number of data bytes processed by Oracle GoldenGate.
0 Comments
Oracle GoldenGate can replicate data across time zones. This blog explains the timezone related features and discusses the best practices. You have to synchronize replication hub's operating system clock with the source/target database clock. Time Zone Related Features There are three places where time zone matters: the time-based data, the lag time report, the trail file I/O time.
Best Practices for Handling Time Zones in Remote Capture and Delivery When performing remote capture and delivery across time zones, such as the replication hub architecture shown as follows, you need to configure Oracle GoldenGate to be aware of the time zone differences between the source database and the OS running Oracle GoldenGate process (including extract and replicat). You can choose any time zone for a replication hub (e.g., an Oracle GoldenGate Cloud Service (GGCS) instance) because it doesn’t affect the replication. Which time zone should I choose for my GoldenGate replication hub? You can choose any time zone for your replication hub. No matter where you run the GoldenGate extract and replicat processes, the timezone in data records stay intact. They are replicated in source database timezone along with the source database time zone information in the trail file. If you have a choice, then choosing the same time zone as the source database. If the source database timezone and the Oracle GoldenGate timezone have to be different, i.e. when you use downstream capture or remote capture, you then need to use SETENV to set to source DB OS time zone and use send <extract/replicat_group> status to retrieve the lag report. It is recommended to:
Lag time is an important metric to monitor the quality of a real-time data replication. This blog explains what a lag time is, how to track lag times in Oracle GoldenGate and the typical methods that you can use to reduce to the lag time. What is Lag Time? Lag time or sometimes just call the "lag" refers to the period between the database operation (DML or DDL) is committed on the source and the current point in time. In Oracle GoldenGate, there are lag times for the extract and replicat:
How to resolve a lag unknown issue? If GoldenGate instance runs on an OS in a timezone different from the source database, you can get the lag unknown issue. Please refer to How to Resolve the Lag Time Unknown Issue for the details. How to Monitor the Lag Time To monitor lag time, you can query the extract and replicat processes or create a heartbeat table to check the end-to-end lag.
How to Reduce the Lag Time To reduce lag time, you need to know what processes contribute to the lag time [1]:
More to Read The detailed lag tuning discussion is available at: How to Reduce the Lag Time of Oracle GoldenGate Replication. Resources
Created 7/2/2015, Last Updated 11/27/2017
Data replication tools like Oracle GoldenGate allows you capture, transform and deliver the real-time data across the heterogeneous platforms. The replication technology is used in a wide range of IT initiatives. But if this is the first you look at the technology, you may ask "Why do I need to replicat data in the first place?" Let's talk about this in this blog. In summary, there are four main reasons:
1. Simplifying the IT Management IT management is a complicated and stressful process. Replication tools like Oracle GoldenGate can streamline the process and reduce the stress in the following ways:
2. Reducing the Total Cost of Ownership (TCO) Everyone wants to get more things done with less spending. Reducing the cost is a forever hot topic in the IT planning. Replication tool can save your cost in the following ways:
3. Setting up for Maximum Availability You can't afford downtime for mission critical databases. Oracle GoldenGate is part of the database maximum availability strategy so that the system to continue working even if some of its parts have failed. . These includes:
4. Enabling the Creative Use of Data The creative use of data can give you the advantages in business such as keeping the data geographically close to users for low latency and scaling out the number of machines that can provide data services. You can use Oracle GoldenGate to create the following services:
These are just some examples. You can use the technology in your own creative ways. Enjoy using the tool. Resources Created 8/15/2017, Last Updated 11/17/2017
|
Oracle GoldenGateThis blog has updates, tips and tricks for Oracle GoldenGate. Categories
All
Archives
April 2018
|