Autonomous

How to deal with statistics when you migrate?

Have you done migration projects in the past, or do you have some upcoming projects, and you wonder how you should treat all sorts of statistics in your database? What is the better option? Keep and migrate the existing ones? Regather them right away? A partial-move approach? How to deal with statistics when you migrate? Then this is for you. Sign up to our next Virtual Classroom Seminar on Thursday, June 18 at 14:00h CEST: Statistics and Migrations – Well-Kept Secrets Revealed

How to deal with statistics when you migrate?

Photo by Mika Baumeister on Unsplash

What’s the topic?

Statistics and Migrations – Well-kept Secrets Revealed…

Recap AIOUG OCYatra 2025 – a trip through India

Posted on July 31, 2025 by Mike.Dietrich Autonomous Database - ADB AutoUpgrade Workshop 0

I just returned the other day from the most strenuous trips I do once a year: The AIOUG Oracle Community Yatra tour. 6 cities in 9 days. It’s a wild ride with flights and bus transfers in between, monsoon rain, heat and nasty mosquitos – but it is still one of the most exciting trips I do. So, let me recap AIOUG OCYatra 2025 – a trip through India. And explain what’s so special about it.

But at first, a huge THANK YOU to the organizers, especially to Sai and all the volunteers making this a …

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

Posted on February 24, 2025 by Mike.Dietrich Autonomous Database - ADB Performance Tuning SPA - SQL Performance Analyzer 2

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 …

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

Photo by Weichao Deng on Unsplash

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 …

Thank you, Barcelona – I’ll be back soon :)

Posted on December 11, 2019 by Mike.Dietrich Workshop 1

I stopped more or less watching Champions League football since it is available on pay TV only for over a year in Germany. But of course I saw the result yesterday: Barca lifting Dortmund into the play-off stage by beating Inter in Milano. Well, I guess, all BVB fans will have celebrated yesterday night. Still, the reason for my blog post is not football. But I’d like to say Thank you, Barcelona – I’ll be back soon 🙂

On Monday, Dec 9, 2019, I held a full day upgrade workshop in Barcelona. The Oracle ACS team did all …

AutoUpgrade: Where do you find all the logfiles?

Posted on July 16, 2019 by Mike.Dietrich AutoUpgrade 16

AutoUpgrade: Where do you find all the logfiles? In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

Posted on July 12, 2019 by Mike.Dietrich AutoUpgrade 57

Photo by Debby Hudson on Unsplash

In the previous blog posts I explained mainly how to create, alter and tweak the configuration file for the AutoUpgrade tool. By now you should have your config file set up and adjusted for your environment(s). Let me go a step further and explain the different processing modes of AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes. Then you’ll have a precise idea what the tool is actually doing, and how it operates.

AutoUpgrade – Step-by-step

Config file for AutoUpgrade – Tweaking init parameters

Posted on July 9, 2019 by Mike.Dietrich AutoUpgrade 3

In the previous blog posts I explained how to generate a sample config file for the AutoUpgrade tool and how to adjust it. Then I gave you an overview about the most important Advanced Options you may want or need to deal with when using the utility. And in the below blog post I would like to show you have you need to edit the Config file for AutoUpgrade – Tweaking init parameters is an important topic.

This is the forth post of a series of blog posts regarding the new AutoUpgrade tool. Please find all the other available …

Autonomous

Recap AIOUG OCYatra 2025 – a trip through India

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

A little bit of background on SPA

Thank you, Barcelona – I’ll be back soon :)

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

AutoUpgrade – Step-by-step

Config file for AutoUpgrade – Tweaking init parameters

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts