Featured
The Latest
-
Using Oracle’s Lock-Free Reservable Columns with GoldenGate
Oracle’s lock-free reservations, introduced in version 23c, address the issue of concurrent transaction blocking when updating specific columns. This functionality… READ MORE
-
GoldenGate Microservices Initial Load Instantiation with WebUI
Every GoldenGate configuration requires an initial instantiation of the target database, often referred to as “Initial Load”. GoldenGate for Oracle is very flexible… READ MORE
-
GoldenGate Replicat? Which one should I use?
Oracle GoldenGate Replicat is a software program that plays a crucial role in data replication within the Oracle GoldenGate data… READ MORE
-
What? GoldenGate Logs with Postman?
Did you know you can check the GoldenGate logs from #Postman? Check it out and unleash your creativity with GoldenGate… READ MORE
-
Product Management vs. Product Ownership – Tell me the difference
Recently, I have been getting these questions quite often, so I decided to give “my” generic point of view about… READ MORE
-
Part 2 – Build GoldenGate Bi-Direction Replication in few minutes on Docker
Now that we have completed Part 1 to set up the Container infrastructure, it’s time to create the GoldenGate replication. The… READ MORE
-
Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes
Introduction: This Part 1 post will show you how to create a GoldenGate Free 23.3 (Hub) that connects to two… READ MORE
-
GoldenGate Microservices Benefits over Classic Architecture
Every once in a while, I’ve gotten a question about what are the main advantages of Microservices Architecture over Classic… READ MORE
-
No PK with GoldenGate?
When Oracle GoldenGate encounters tables without a primary key (PK) for data replication, it has different approaches depending on the… READ MORE
-
Latest GoldenGate/Database Patch recommendations
Always make sure to have the latest patches. Latest GoldenGate/Database (OGG/RDBMS) Patch recommendations (Doc ID 2193391.1) https://support.oracle.com/knowledge/Oracle%20Database%20Products/2193391_1.html READ MORE
-
Enable ACDR for all tables in a GoldenGate Bi-Directional Replication
An essential consideration when configuring Oracle GoldenGate for bi-directional or multi-directional (active-active) data replication is the potential for data collision,… READ MORE
-
Find the Archived log from a SCN
From time to time you might need to find out where a particular transaction is in the redo logs. Most… READ MORE
-
Disk Space Alert Monitoring
Back from my archives, I thought to share this simple and decent script to monitor file systems. READ MORE
-
GoldenGate Free 23c from Docker Hub
Download the GoldenGate Free 23c image from Docker Hub for quick deployment. https://hub.docker.com/r/alexlima/goldengate-free Get Oracle GoldenGate up and running in… READ MORE
-
Oracle Data Pump Filters GoldenGate ACDR Columns from Tables
The ACDR feature of Oracle GoldenGate adds hidden columns to tables to resolve conflicts when the same row is updated… READ MORE
-
Per-PDB Capture in GoldenGate 23c
GoldenGate Free 23c now supports per-pluggable Database (per-PDB) capture (Only). Oracle GoldenGate 23c (23.3) enables you to grant privileges to users… READ MORE
-
New GoldenGate Capture and Apply Roles in 23ai
Simplification for GoldenGate User privileges in 23c. Check out the new roles in Oracle Database 23c for GoldenGate. #oracle #oraclegoldengate… READ MORE
-
Automatic CDR Enhancements in 23c
Automatic Conflict Detection and Resolution (ACDR) was introduced in Oracle Database 12c Release 2 (and Oracle GoldenGate 12.3.0.1) to automate… READ MORE
-
Download Now the New GoldenGate 23.3
GoldenGate 23c Free Oracle GoldenGate 23c Free is the same, powerful Oracle GoldenGate that businesses throughout the world rely on.… READ MORE
-
Docker Cheatsheet Commands
List of all running and not running containers: docker container ps -a READ MORE
-
How to find total size of partition table on Postgresql?
To find total size of partition table on Postgresql, one can run following query. Note this show table size only READ MORE
-
Executive MBA me? Who would thought?
Back in April 2023 I joined the Quantic Executive MBA Cohort July 2024. Quantic School of Business and Technology offers… READ MORE
-
Oracle Q422 Results are out and beat estimates
Oracle’s fourth-quarter numbers are in, and here are a few key insights. It’s impressive to watch how Oracle is gaining… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
Alex Lima 