Changes

New AutoUpgrade version 26.6 is available

Yes, the long-awaited new AutoUpgrade version 26.6 is available for download. Again, a fantastic job by our development team. And I know that many of you were waiting for it already since it has some really cool new features, enhancements – and of course, fixes, too.

New AutoUpgrade version 26.6 is available

Photo by Jason Leung on Unsplash

Download AutoUpgrade

As I described already in AutoUpgrade Patching – From Zero to Hero – Part 1: Download AutoUpgrade, you have several ways to fetch the newest version of AutoUpgrade – and when you use it to download patches, it will automatically trigger an update with the …

Continue reading...

DBMS_OPTIM_BUNDLE and the standby database?

I could have sworn that I had blogged about it. Aleksey had a comment on the blog and I could not find the answer. But I knew that I had discussed this topic with several people in email already. Maybe it has fallen off my long list of future blog posts. No worries, here it is: DBMS_OPTIM_BUNDLE and the standby database?

DBMS_OPTIM_BUNDLE and the standby database?

Photo by 张 嘴 on Unsplash

DBMS_OPTIM_BUNDLE – short recap

I have a longer list of DBMS_OPTIM_BUNDLE blog posts, and you can easily navigate to them here. In very short, you will use the package to enable potentially …

Continue reading...

Important Update to Oracle Database 19c Support Timelines

Long silence doesn’t mean that I am hiding. It just means that it’s very busy right now. And hopefully with less travel I will have more time to blog and reply also to your comments. Still, let me tell you about a very Important Update to Oracle Database 19c Support Timelines.

What has been updated?

As of November 19, 2024, the Support timelines for Oracle Database 19c have been adjusted. When you look at MOS Note: 742060.1 – Release Schedule of Current Database Releases you will see the new dates:

  • Premier Support until
… Continue reading...

ORAdiff is live – compare two Oracle Database and Patch releases

Did you ever wanted to find out the differences between two Oracle database releases? Today, I am super-super excited. Especially, since this was a long journey. And I have to thank our entire team,  Rodrigo especially but also Bill and all the others working and helping here. THIS is the tool many of you have looking for since years. It is time now, ORAdiff is live – compare two Oracle Database and Patch releases.

ORAdiff is live - compare two Oracle Database and Patch releases

What is ORAdiff?

This tool is made for you. It allows you to compare two Oracle releases to each other. And not only core …

Continue reading...

Effect of GDPR / DS-GVO on blogs and other pages

This is not a database knowledge article. I more or less see this as a information collection and discussion point. An important topic for me at the moment, besides all the usual upgrade and migration things, is about the effect of GDPR / DS-GVO on blogs and other pages.

A Quick Recap

Effect of GDPR / DS-GVO on blogs and other pagesMy GDPR journey started last October in Slovenia at the User Group Conference. I attended Philippe Fierens’ and Pieter van Puymbroeck‘s very cool and refreshing talk about GDPR. What is GDPR? I guess you have heard of it already. It is the General Data …

Continue reading...

DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not?

DBMS_OPTIM_BUNDLE - only available in Oracle 12.1.0.2The DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata 11.2.0.4 Bundle Patch. And it got introduced for all Oracle 12.1.0.2 databases with the April 2017 Bundle Patch (BP). DBMS_OPTIM_BUNDLE is only available in Oracle 12.1.0.2.

Addition March 6, 2018:
See the updated blog post about DBMS_OPTIM_BUNDLE available in Oracle 12.2 and 18c onwards.
https://mikedietrichde.com/2018/03/08/dbms_optim_bundle-package-oracle-12-2-18c/

For more information on this package on Exadata in Oracle 11.2.0.4 you may look at:

Purpose of DBMS_OPTIM_BUNDLE package in Oracle 12.1.0.2

The package got introduced to enable module bug fixes which …

Continue reading...

Default Changes SPFILE Parameters – Oracle 12.2

This is the 4th posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.

Roy and I did a comparison between default parameter settings in Oracle Database 11.2.0.4 vs Oracle Database 12.1.0.2 vs Oracle Database 12.2.0.1. And some changes are quite interesting – of course the memory driven parameters are left out in this list.

Color RED marks a change between releases.
The databases were …

Continue reading...