Golden Gate Interview Questions

January 19, 2013  |   Moved   |     |   0 Comment

1. How is Golden Gate different than streams?
Oracle GoldenGate uses trail files to transfer data to the target while Streams uses a dblink to transfer data to the destination.

2. What are the area’s to monitor in Golden Gate?
The lag and checkpoint latency for the Extract, pump and replicat are normally monitored.

3. What type of Replication does Golden Gate support?
Oracle Golden Gate support DML and DDL replication.

4. What are some of the tuning parameters used for Golden Gate?

5. What databases does Golden Gate support for source and target?
Some of the more popular databases supported are:
- Oracle
- MS SQL Server

6. How do you look at the data which is extracted?
The Golden Gate logdump utility has to be used to look at the RBA and the data at that point.

7. In the trail files, how do you find transactions which are larger than a particular size?

8. What are common possible reasons that the Extract process will slow down?
Some of the common possible reasons are:
- Long running batch transactions in the database
- Insufficient memory set for on running transactions causing writing of the uncommitted transaction to the temporary area.

9. What are common possible reasons that the Replicat process will slow down?
Some of the common possible reasons are:
- If using DBFS, writing and reading of trail files may be slow if the SGA parameter are not tuned.
- For slow replicat’s latency may be due to missing indexes on target.
- Replicat having to process Update, delete of rows in very large tables.

10. What type of encrption is supported in Golden Gate?
Oracle Golden Gate provides 3 types of encrytion. They are:
- Data encryption using Blow fish.
- Password encryption using encyrption key.
- Network encryption.

11. Where can filtering of data in a particular column take place, using Golden Gate?
Filter of columns fora table can be done at the Extract, Pump or the Replicat level.

12. What steps would you use to add a new table to the destination replicat?
The steps would be along the following:
- Include the new table to the extract & pump process.
- Obtain starting database SCN and Copy the source table data to the target database
- Start replicat on target at the source SCN database point.