Type something to search...

Blog

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
BKUP_API and disappearing Incremental Backups

BKUP_API and disappearing Incremental Backups

Some time ago, I noticed that the bkup_api hadn’t completed any Incremental Backup for one of the databases on Exadata Cloud@Customer for several days. More importantly, it failed to notify o

Read More