Type something to search...

Blog

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
Welcome

Welcome

Hey there! Looks like I’m starting a blog! I’ll be sharing all sorts of things that pop up in my day-to-day - whether it’s something I’m tackling at work, or just random fun stuff. Honestly, for fun

Read More