Real-time data streaming has simplified transformations and kept enterprise databases synchronizedOracle GoldenGate is good, but I would like to improve it. There is a need for whoever installs and configures Oracle GoldenGate to set the correct parameters for the use cases we need to use. In some cases, we had performance problems related to the streaming because there was a lot of information to stream concurrently. However, you can tune Oracle GoldenGate to use more RAM on the source side or more processes. I think that sometimes what is missing is knowledge about the tool from the person responsible for configuration. At this moment, Oracle GoldenGate is a very good tool, and I do not know in which area we can improve it. Perhaps the debug part of the tool could be improved. In some cases, I use the utility for how Oracle GoldenGate generates messages about the statements that it streams because of bugs, and in some cases, it is not very user-friendly. It may be possible to improve the API or the path related to debugging, but not the tool itself. The tool itself is good. I remember that in some configurations, we had problems with the streaming of DDL, which are changes to Oracle object structures such as tables and procedures. A new feature could be to perform streaming for operational objects such as procedures, functions, packages, or grants. This would synchronize source and target for these aspects, not only for data or the main types of structures, but also for others. I remember that there was some configuration in which you performed the streaming of the entire schema, or if you performed streaming for only tables, then you were unable to stream grants and other Oracle objects. I think it is important to introduce that capability.
