Cloud

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…

Transportable Tablespaces with M5 scripts support now 26ai

Posted on February 4, 2026 by Mike.Dietrich Minimal Downtime Transportable 4

We have a lot of information in our seminars and blogs about Transportable Tablespace migrations. And since we have the M5 scripts for RMAN incrementally rolled forward backups and new RMAN functionality which avoids the spare storage, life has gotten so much easier. Now, some great news from the authors of the M5 scripts: Transportable Tablespaces with M5 scripts support now 26ai.

Transportable Tablespaces with M5 scripts support now 26ai

Photo by Mathew Antony on Unsplash

M5? Almost as fast as the car!

Some of you may still know the V4 PERL scripts. They had an evolution from V1 to V4 over the years and were our …

Queries on dictionary tables are slow in Oracle Multitenant?

Posted on February 10, 2025 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 12

I love to learn something new every day. And on Friday afternoon last week I learned something new again. It started (as often) with a very simple question from a colleague working from the Oracle Malaga office in Spain. The customer has an issues with some queries being slower than before once they moved from on-prem to the cloud into a PDB. But are queries on dictionary tables are slow in Oracle Multitenant generally?

Queries on dictionary tables are slow in Oracle Multitenant?

Photo by Pascal van de Vendel on Unsplash

What was the case?

The customer ran some queries against dictionary views in the PDB in Oracle Database …

Oracle Database 23ai is available in the cloud and as Free

Posted on May 2, 2024 by Mike.Dietrich Oracle Database 23ai 23

You may have watched the announcement of Larry Ellison together with our EVP Juan Loiza this evening. And yes, Oracle Database 23ai is available in the cloud and as Free Developer Edition as of now.

Oracle Database 23ai announcement by Larry Ellison and Juan Loiza

Click on the picture to watch the announcement

What are we announcing?

Please see the important links for more information about the recent announcements Larry Ellison and Juan Loiza made today.

Oracle Database 23ai – Overview blog post
This blog post gives you a very detailed overview on the key features, and why it is called Oracle Database 23ai. Find out more about the 300+

A new version 24.1.0 of CPAT is available

Posted on April 9, 2024 by Mike.Dietrich CPAT 0

No worries, this blog won’t become a “new version” announcement blog. But after two weeks of relaxing Easter holidays I just start cleaning up my inbox and flushing out blog posts as soon as time allows. One thing I need to share with you is that a new version 24.1.0 of CPAT is available for download. CPAT? You may not have read about CPAT on my blog yet. But this will change in the future since the CPAT development is now part of our small team as well. And we get happily tied into more and more Autonomous Database (ADB) …

Welcome aboard at Oracle, Alex Zaballa

Posted on December 14, 2023 by Mike.Dietrich General 1

Our PM team is slowly growing – and I am so happy about our newest team member. Welcome aboard at Oracle, Alex Zaballa!

Photo by Diogo Monteiro on Unsplash

Now I think I need to start learning a bit more Portuguese. Rodrigo is located in Brazil, and Alex relocated a while ago to the US but is Brazilian as well. I am really excited to have another super-smart guy in our team helping us with upgrades, (cloud) migrations, patching, Cloud Migration Advisor and CPAT, and other cool things. Personally, I enjoy working with people who have such a deep knowledge …

DBUA Deprecation and future Desupport in Oracle Database 23c

Posted on June 21, 2023 by Mike.Dietrich AutoUpgrade DBUA Deprecated / Desupported 16

Daniel pointed me to Tim Hall’s blog post about deprecated and desupported features in Oracle Database 23c. And his first bullet point mentioned is the DBUA Deprecation and future Desupport in Oracle Database 23c. Since Daniel and I agree that this needs a bit more explanation, we would like to share more background information with you.

Photo by Ajeet Mestry on Unsplash

Deprecated vs Desupport?

At first, let me refresh an old topic. What does deprecated mean, and what is the difference to desupport? A long while ago I wrote this blog post about it, and nothing …

We are hiring … Developers and a Product Manager

Posted on March 29, 2022 by Mike.Dietrich Job Offering 0

Our team is growing – not only the Upgrade team but also the Data Pump team. And we have a challenging new project where we search developers for. So yes, We are hiring … Developers and a Product Manager.

We are hiring ... Developers and a Product Manager

Photo by Ashley de Lotz on Unsplash

Software Developer – Cloud Migration Analyzer

At first, we are looking mostly for skilled developers. We have a new challenging and interesting project which our VP, Roy Swonger, owns. And there we look at first for developers with either very good APEX skills but also database knowledge or people who are good in programming …

Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD

Posted on January 21, 2021 by Mike.Dietrich Workshop 7

It took a while. And many of you asked whether we will run our Virtual Classroom Seminars we ran successfully for Australia and New Zealand in April and from June to now in EMEA for the US, Canada and South and Latin America time zones as well. And we do. It’s time to Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD.

Photo by Philippe Bout on Unsplash

Everything you need to know about Upgrade, Migration and Consolidation

When we ran these events especially for EMEA, a lot of colleagues asked us whether …

Recap: Support Periods for Oracle 11.2.0.4, on-prem and in the cloud

Posted on December 17, 2020 by Mike.Dietrich Cloud Release Schedule 6

You may have recognized that I don’t update the blog as frequent as usual. But these times are very busy with plenty of conferences and many of our customers preparing for the move to 19c in the more quieter period of the year. And this is the right time to do a quick recap: Support Periods for Oracle 11.2.0.4, on-prem and in the cloud.

Recap: Support Period for Oracle 11.2.0.4, on-prem and in the cloud

Photo by Arnaud STECKLE on Unsplash – this car is a VW Karman Ghia

11.2.0.what?

Ah, well. Do you remember when Oracle Database 11.2.0.1 got released?

No worries, I’ve had to look it up by …

Upgrade Essentials – Videos for the Virtual Classroom Series 2020

Posted on November 10, 2020 by Mike.Dietrich Video / Viewlet Workshop 0

Roy, Daniel and I ran 6 workshops in our Virtual Classroom Series 2000 format. Each of them is between 90 and 120 minutes. This sounds quite long but of course you can scroll forward if you are interested in only a part of it. We consider those the Upgrade Essentials – Videos for the Virtual Classroom Series 2020. As as we now completed the 6th web seminar, it’s time for a short recap.

Upgrade Essentials - Videos for the Virtual Classroom Series 2020

Photo by Niamat Ullah on Unsplash

Is Upgrade that complicated?

Good question. If upgrade is so easy as we say, why do you need 6 virtual sessions …

Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com

Posted on August 10, 2020 by Mike.Dietrich Cloud 0

You may have realized that you will find mostly on-prem database upgrade and migration topics covered on my blog. Which doesn’t mean that you can’t use most of these techniques to migrate to the cloud either. But it’s really hard to write about everything in full detail. Hence, today I’d like to introduce you to Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com. And no, I was never a fan of this American boyband from the 80s and 90s 😉

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Find Daniel’s blog at: https://dohdatabase.com

DOHDATABASE … huh?

Daniel Overby Hansen

As you may have read a …

Upgrade Testing with a Refreshable PDB – does this work?

Posted on May 5, 2020 by Mike.Dietrich Single-/Multitenant 13

Yesterday, Daniel pinged me to discuss an upgrade testing scenario I had evaluated briefly by myself a while ago. I can’t remember why I gave up. But Daniel had some great ideas and tried already a lot in our OCI cloud. We want to use a refreshable PDB. And keep it up to date, then upgrade it. The idea of this approach: Whereas a CLONE or RELOCATE uses the initial command as the marker, a REFRESH would allow me to be way more in synch. So the question is: Upgrade Testing with a Refreshable PDB – does this work?

Upgrade Testing with a Refreshable PDB - does this work?

Photo

Welcome onboard: Daniel Overby Hansen as Cloud Migration PM

Posted on January 6, 2020 by Mike.Dietrich General 0

I’m very happy to announce that as of January 1, 2020 a new decade begins. And Daniel Overby Hansen joins our group as new Cloud Migration Product Manager. I worked with Daniel on the customer side at SimCorp for many years. When we had a job opening in our group, we were very happy when Daniel applied for the opportunity.

Welcome onboard: Daniel Overby Hansen as Cloud Migration PM

Photo by Nick Karvounis on Unsplash

Who is Daniel?

Daniel Overby Hansen – Senior Principal Product Manager – Cloud Migrations – Oracle

Daniel has many years of experience in building enterprise-grade software from the Danish global provider of financial software, …

OOW 2019 – Database Upgrade Talks and Labs

Posted on September 11, 2019 by Mike.Dietrich OOW 0

Oh … time flies so fast. Just a few days until I will sit in a airplane to SFO. And on Monday at 7:00h the registration opens. As we have a lab at 8:30h already, just remembering the loooooong lines around the block last year, I will need to be there very early. It’s just a few days until OOW 2019 – Database Upgrade Talks and Labs information is here.

OOW – Oracle Open World 2019 in San Francisco

OOW 2019 - Database Upgrade Talks and Labs

Photo by Robert McLay on Unsplash

When? September 16-19, 2019

Where? San Francisco, USA

What? Find the session catalog here…

How long can you provision database version X in the Cloud? – NEW

Posted on November 26, 2018 by Mike.Dietrich Cloud Release Schedule 0

A few weeks ago I published a blog post about provisioning dates in Oracle Cloud environments for different databases releases. As we did an important update, I rewrite today: How long can you provision database version X in the Cloud? – NEW.

What has changed since the original post?

The key point in the previous blog post was:

“And by end of this calendar year, the option to provision an Oracle 12.2.0.1 instance will go away. The same will happen in less than 1 year with Oracle 11.2.0.4 instances.”.

With “this calendar year” I pointed to end of 2018. …

OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers

Posted on October 15, 2018 by Mike.Dietrich OOW 2

OOW 2018: Cloud Migration from AIX to ExaCC - for DBAs and managers

Yes, OOW starts next week. And I’d like to introduce the third of our 4 talks. And let me say upfront about this talk at OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers. This is not the usual “cloud” talk 🙂 The official title is: Oracle Database Cloud Migration: Fast, Simple, Universal. Well, we should discuss the “simple“. But that’s why you want to see this talk. It will happen on Thursday, 9:00 a.m.. Hence, remember to leave the party the night before not too late. You need to be awake when …

How long can you provision database version X in the Cloud?

Posted on August 3, 2018 by Mike.Dietrich Cloud 2

That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 12.1.0.2 for instance?

How long can you provision database version X in the Cloud?

Please find the updated blog post here:

How long can you provision database version X in the Cloud? – NEW

–Mike…

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)

Posted on April 30, 2018 by Mike.Dietrich Cloud Patch Recommendation 8

I was quite surprised when I spotted the Update (RU) Oracle 18.2.0 mid of April in my OCI Classic (DBCS, DBaaS) account. Of course I was thrilled immediately and started the patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic).

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)

The April 2018 Updates (and Bundle Patches and Patch Set Updates for Oracle releases below 12.2) got released on April 17, 2018. You can read more here on how I applied all of them to my Oracle 11.2.0.4, 12.1.0.2 and 12.2.0.1 databases. But I was positively surprised when …

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

Posted on April 5, 2018 by Mike.Dietrich Cloud Single-/Multitenant 6

There’s been silence for a while – but today I’d like to show you how to unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud. I’m doing this exercise because I’ve seen questions already. And I was curious if it works as I’d expect it.

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

As usual I will use our hands-on lab environment – and a freshly deployed 18c OCI-Classic instance (formerly known as DBCS formerly known as DBaaS).

Unplug a 12.2.0.1 PDB and plugin into 18c inthe Cloud

It is a Single Tenant environment with one PDB. If you need for information about how to …

When will Oracle Database 18c be available on-prem?

Posted on March 20, 2018 by Mike.Dietrich Oracle Database 18c 14

When will Oracle Database 18c be available on-prem? Some of you will answer: It is available already, isn’t it? And you are right. But I don’t want to blog just a marketing message but some facts. Others may ask: When will it be generally available on-premises?