BigDBA – Database,Devops,Big Data,Cloud & Oracle Blog

For years, the phrase “database upgrade” has triggered a sense of caution among Database Administrators. The traditional process—manually checking cross-references, verifying patches, and assessing risks—was time-consuming and prone to human error. However, the landscape of the Maximum Availability Architecture (MAA) is changing.

In this guide, we w...

If you are an Oracle DBA or a Backup Administrator, you probably know that feeling when a routine restore suddenly hits a wall. Recently, while working on a standby database setup, I ran into a particularly stubborn error: ORA-19511.

The error stack looked something like this: Failed to get repository by ID: {00000000-0000-0000-0000-000000000000} Fa...

This guide shows you how to set up EDB BDR (which lets you write to all servers) using ZFS for your storage. We include sample outputs to help you follow along.

ZFS is a great choice here. It’s from Oracle and helps protect your data, much like ASM. It checks for errors (checksumming) and prevents broken data blocks (“torn pages”). This makes your database setup ver...

This document provides a clear comparison of the concurrency control models in PostgreSQL and Oracle. While both databases use MVCC, their implementation is fundamentally different. Understanding this is key to managing performance. We’ll dive into the core differences, from PostgreSQL’s Heap Tuple (t_xmin/t_...

You’ve seen it in your alert.log or a system message—a cryptic warning hinting at “unused large pages.” First, let’s correct the common typos and interpret the message. The warning: unused large pages exist system wide at or near 100% means that your Linux operating system has dutifully allocated a large chunk of RAM as HugePages, but your Oracle database instance has complet...