Posts

Showing posts from June, 2025

Oracle Zero Downtime Migration(Oracle ZDM) - Overview

Oracle ZDM is a software solution which allows you to directly and seamlessly migrate your on-premises Oracle Databases to and between any Oracle-owned infrastructure, including Exadata Database Machine On-Premises, Exadata Cloud at Customer (ExaC@C), and Oracle Cloud Infrastructure. Oracle Zero Downtime Migration (ZDM) is designed using Oracle's best practices for high availability. It uses tools like Golden-Gate and Data Guard to keep your database available during migration, and relies on technologies such as RMAN, Data Pump, and database links to move data efficiently and safely — all with minimal downtime. Oracle ZDM offers four different migration methods: 1. Logical Online Migration using Golden-Gate.     In  logical online migration approach ZDM leverages Oracle Data Pump for the initial export and Oracle Golden-Gate for continuous data replication. Oracle Golden-Gate plays a critical role by capturing and applying real-time changes from the source to the tar...

Row Locking and ITL in Oracle.

Image
Locking is very important aspect in a database. It is must to regulate access to (shared) resource so that one process/user doesn't change it while other is modifying the same. If we question how database may be locking rows/data, we usually may think there may be a process/manager which must be doing the task internally. The manager process maintains the information which process id wants/has to lock particular rows etc. Seems perfect for simple logical explanation, However if we consider this for OLTP systems, we can easily understand that such a single point of control may cause bottleneck. All processes competing for locks(acquire or release) on resources via a single manager will ensure that the application/workload cant scale at all. One of the major reason for Oracle being the top database is the locking mechanism which it implements. There is no such concept as lock manger etc. Oracle places the lock related information in the actual data block itself. Ex:  when a row in a ...