Type something to search...

Blog

RMAN-20036 During Recovery Catalog Resync in Data Guard

RMAN-20036 During Recovery Catalog Resync in Data Guard

When using Oracle Data Guard together with an RMAN recovery catalog, one of the operations you may run regularly is: RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;In a healthy configuration

Read More
How CPU IO Wait Became an ASM Issue

How CPU IO Wait Became an ASM Issue

You know the story? You start the day with a simple plan, but the universe rewrites the script, and before you know it, daylight turns into overtime darkness.It started quietly. No database alerts

Read More
JAS-MIN, Part 2 — Digging Deep into AWR & STATSPACK

JAS-MIN, Part 2 — Digging Deep into AWR & STATSPACK

Welcome to the second post in the JAS-MIN series!In this part, we’ll dive into the most important options that shape how JAS-MIN behaves — and how to tune its sensitivity to detect what is importa

Read More
JAS-MIN, Part 1 — Digging Deep into AWR & STATSPACK

JAS-MIN, Part 1 — Digging Deep into AWR & STATSPACK

It was becoming increasingly difficult to say why and for what purpose what was happening was happening; and worse still — what exactly was actually happening at all.*- Black Oceans - Jacek Duk

Read More
Non standard aproach to STANDARD

Non standard aproach to STANDARD

Last weekend, during a routine migration from a non-CDB Oracle database to a PDB, together with Kamil Stawiarski, we stumbled upon a charming little Oracle behaviour worth

Read More
Wrong Results when SQL offloaded with Smart Scan - case study

Wrong Results when SQL offloaded with Smart Scan - case study

Running a database on an Exadata Database Machine can occasionally reveal unexpected challenges, such as an offloaded SQL query returning incorrect results. This kind of behavior, as you can imagine,

Read More