Featured
The Latest
-
Implementing PII Data Masking in Oracle GoldenGate 23ai Using SQLEXEC
Introduction In today’s data-driven world, protecting sensitive information during replication is crucial for compliance with regulations like GDPR, CCPA, and… READ MORE
-
Extending Oracle GoldenGate Session Timeouts: A REST API Approach
Introduction Oracle GoldenGate Microservices Architecture provides a REST API for managing service configurations. One common requirement is adjusting session timeout… READ MORE
-
Deploy GoldenGate in minutes with the new OCR Image
We are pleased to announce that GoldenGate Container images for commercial customers are now available on the Oracle Container Registry (OCR). This release… READ MORE
-
Unlocking Oracle GoldenGate Logdump: Beyond the Basics
Why Logdump Matters Every Oracle GoldenGate deployment depends on trail files, the immutable record of changes moving between systems. While… READ MORE
-
Quando a força, o poder se torna mediocridade
Existe uma frase que ecoa em minha cabeça a anos e referenciada por um grade sábio amigo: “Dê forças a… READ MORE
-
Checking Table Statistics with GoldenGate REST API
When running Oracle GoldenGate in production, it’s essential to keep track of how many operations are being replicated across tables.… READ MORE
-
Thriving in Corporate Politics: Turning Reality into Opportunity
I’ve worn many hats in my career: employee, consultant, and entrepreneur. And through each stage, I’ve discovered one constant: corporate… READ MORE
-
Oracle GoldenGate: The Critical Use Cases That Matter Most
Over the years, GoldenGate has become the gold standard for real-time, reliable, and mission-critical data replication. But what are the… READ MORE
-
Check for long-running transactions and the nearest dictionary build.
In Oracle replication environments, especially with GoldenGate capture, two factors frequently determine whether your pipeline runs smoothly or starts lagging:… READ MORE
-
GoldenGate Dynamic Table-Level Stats Query with API
Fetching Table-Level Statistics with Oracle GoldenGate REST API Monitoring replication activity at the table level is critical for DBAs and… READ MORE
-
Building a GoldenGate AdminClient Picker for Multiple Deployments
When working with multiple Oracle GoldenGate Service Managers and deployments, navigating AdminClient can be tedious; you need to remember the… READ MORE
-
Os Quatro Pilares do Sucesso: Minha Filosofia Pessoal
Sucesso é uma palavra que significa coisas diferentes para pessoas diferentes. Para alguns, é definido por conquistas na carreira ou… READ MORE
-
The Four Pillars of Success: My Personal Philosophy
Success is a word that means different things to different people. For some, it’s defined by career achievements or financial… READ MORE
-
Preventing Sequence Conflicts in Bi-Directional Oracle GoldenGate Replication
In active-active Oracle GoldenGate environments, where data is replicated in both directions between two or more databases, maintaining data consistency… READ MORE
-
Add TRANDATA for a set of tables (only) with REST
Sometimes, you only need to add TRANDATA to a set of tables, and it’s really easy to automate that with… READ MORE
-
Why a Little Selfishness Is Good for You
When we hear the word “selfish,” it often carries a negative connotation as if caring for yourself automatically means neglecting… READ MORE
-
Clone GoldenGate User
I put together a handy script that reproduces the Data Definition Language (DDL) for an existing GoldenGate user. This friendly… READ MORE
-
Why You Should Build the LogMiner Dictionary Periodically for Oracle GoldenGate
When using Oracle GoldenGate in Integrated Extract mode, one of the most overlooked but essential steps is ensuring that the… READ MORE
-
Query V$DIAG_ALERT_EXT from Oracle Using SQL Panel in Grafana
I was testing the process of retrieving the Alert Log and other diagnostic features from the Oracle Database and GoldenGate… READ MORE
-
Why do we need Checkpoint table?
Configuring a checkpoint table for the Replicat process is highly recommended whenever possible. While support for checkpoint tables varies across Oracle GoldenGate (OGG) and database… READ MORE
-
Script to ADD Schematrandata to 1000s of Schemas
Occasionally, we meet customers with thousands of schemas, a challenge that can seem overwhelming to add schematrandata, for example. However,… READ MORE
-
What is “Authorization: Basic” in the cURL API calls
The -H ‘Authorization: Basic …’ flag in a curl command sets the HTTP Authorization header using Basic Authentication. Basic authentication… READ MORE
-
Is an IT Certification Worth It? Pros and Cons You Should Know
In today’s fast-moving tech landscape, professionals constantly ask: “Do I need a certification to succeed in IT?” Whether you’re a… READ MORE
-
The “cup half full” vs. “cup half empty” – optimistic or pessimistic
Considering yourself realistic instead of optimistic or pessimistic is not bad; in fact, it’s often a strength. The “cup half… READ MORE
-
Veridata REST API
Did you know that with Veridata 23ai, you can now manage your compares through the APIs? Check out the documentation:… 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 