Oracle GoldenGate Articles

Oracle GoldenGate Articles Dear Readers, Please check below articles to get good knowledge on Oracle GoldenGate AWS Cloud. SNO DESCRIPTION ARTICLE LINK 1 Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes https://www.ktexperts.com/shell-script-to-get-email-alerts-for-lagging-between-goldengate-processes/ 2 Shell Script to get EMAIL alerts for STOPPED Processes… Read More

Oracle to MySQL Heterogeneous Unidirectional Replication

Oracle to MySQL Heterogeneous Unidirectional Replication Hello Readers, In this article we will see how to make Heterogeneous Unidirectional Replication between Oracle and  MySQL. Source : Oracle DB(12.1.0) Target :  MySQL(5.7) Download Goldengate Binaries  Download GoldenGate binaries from Oracle.com using below link(Oracle) https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Make sure that you… Read More

Online Segment Shrink

Online Segment Shrink A segment is a logical storage structure that contains data structure (segment type) of database objects. A segment is a set (unordered) of extents. A segment and all its extents are stored in one tablespace. From Oracle Database 10g, we can use the segment shrinking capability to reclaim unused… Read More

Oracle Security Audit: SQL92_SECURITY

SQL92_SECURITY   Oracle Security Audit: Q:  How to improve security level for DML transactions?. Ans: By setting the SQL92_SECURITY parameter we can improve the security level for DML transactions. The configuration option SQL92_SECURITY specifies whether table-level SELECT privileges are required to execute an update or… Read More