Report

AHUBFILE files in ASM in Oracle 23ai – what is it?

I really love our customers. Many people are so super-smart. A few weeks ago I delivered a full-day hands-on workshop for ora2know in Munich and some (positively) crazy people fly in very early morning from the other end of Germany to attend. Others catch a train at night time (which is the bigger adventure in Germany these days). I feel really grateful since this was also a pay-for-it workshop. It was a great day, I’ve had lots of fun – and the attendees hopefully as well. Dagmar sent me an email a few days later with the subject similar to …

Continue reading...

ADB Migration: Why does my SPA report has so many errors?

I’m dealing lately with several migration to Oracle Autonomous Database, mostly to ADB Serverless (called “shared” a while ago, in short: ADB-S). With one of the customers we run SQL Performance Analyzer reports with about 1500 statements. But one topic came up in this ADB Migration: Why does my SPA report has so many errors? Let’s see why that is …

A little bit of background on SPA

The SQL Performance Analyzer (SPA) is one of the two pieces of Real Application Testing. This is a feature in the database I keep using …

Continue reading...