SPM

Some very important MOS Notes when you upgrade and patch

Posted on May 27, 2021 by Mike.Dietrich Patch Recommendation 16

Today, I would like to publish only a short blog post with some hints to MyOracle Support (MOS) notes we find quite helpful. The idea of all these notes I will list below is to help you finding the right patches before you upgrade or patch to Oracle 19c. So see our collection of Some very important MOS Notes when you upgrade and patch below.

Some very important MOS Note when you upgrade and patch

Photo by Jacques Dillies on Unsplash

Why do you need patch bundles?

At first, it is always our recommendation to upgrade to the most recent Release Update (RU). This is currently Oracle 19.11.0 while I’m …

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Posted on May 2, 2020 by Mike.Dietrich Workshop 2

Thanks a lot to all of you who participated also in our second seminar. Below you find now 3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered.

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Photo by Karl Lee on Unsplash

Your Questions, our Answers for Seminar 2: Upgrade and Performance

I this blog post I answer all questions from the second seminar about AutoUpgrade to Oracle 19c and Performance Stability. Please find the links to the other QAs for Seminar 1 (Release Strategy, Patching and Cool Features) and Seminar 3 (Migration to Multitenant) below in the Links section of this blog post.

We need

The new Oracle 19c Hands-On Lab is available now for download

Posted on February 6, 2020 by Mike.Dietrich Hands-On Lab 0

Wow, this took a long while. Thanks to my team mate, Data Pump Product Manager Bill Beauregard who went through the complex approval process, the new Oracle 19c Hands-On Lab is available now for download. And in addition, I adjusted the instructions on the blog as well.

The new Oracle 19c Hands-On Lab is available now for download

Photo by Kenrick Mills on Unsplash

What you’ll get …

At first, the download is huge. All together, you will download 13 files summing up to 25GB. When you unzip it, you will get an OVA file. Then you will need to import this appliance into Oracle VirtualBox. The lab will …

Automatic SQL Plan Management – Slight Change with 19.4.0

Posted on October 2, 2019 by Mike.Dietrich Oracle Database 19c SPM - SQL Plan Management 2

I did blog in more detail about Automatic SQL Plan Management in Oracle 19c. And Roy and I had really a lot of discussion in every customer meeting at OOW19 about it. But there is a slight change to where the feature is available with Oracle 19.4.0.

Photo by Samuel Zeller on Unsplash

Slight Change

When you compare the settings of SQL Plan Management between Oracle 19.3 and 19.4, you’ll see the difference:

column parameter_value format a45
column parameter_name format a25
set pages 200

SELECT PARAMETER_NAME, PARAMETER_VALUE
  FROM   DBA_ADVISOR_PARAMETERS
  WHERE  TASK_NAME = 'SYS_AUTO_SPM_EVOLVE_TASK'
    AND PARAMETER_VALUE <> 'UNUSED'
  ORDER

Automatic SQL Plan Management in Oracle Database 19c

Posted on June 3, 2019 by Mike.Dietrich Oracle Database 19c SPM - SQL Plan Management 6

When you upgrade to a new database release, there will be changes. Some are obvious, others are not. This one is somewhere in between because it is documented quite well but not very well known yet as far as I see. I’m talking about the Automatic SQL Plan Management in Oracle Database 19c.

What is changing in Oracle 19c?

PLEASE READ THIS UPDATED BLOG POST:
https://mikedietrichde.com/2019/10/02/automatic-sql-plan-management-slight-change-with-19-4-0/
AS THERE IS A CHANGE WITH ORACLE 19.4.0.

First of all, I don’t want to rewrite everything Nigel Bayliss wrote in his detailed blog post about Automatic SQL Plan Management in Oracle 19c …

SQL Plan Management – Known Issues in Oracle 12.1.0.2

Posted on September 14, 2015 by Mike.Dietrich Patch Recommendation SPM - SQL Plan Management 6

Our Support colleagues released the patch recommendation note for SQL Plan Management (SPM) for Oracle Database 12.1.0.2.

MOS Note:2035898.1
Patches to Consider for 12.1.0.2 to Avoid Problems with SQL Plan Management (SPM)

SPM Note

In the unlikely event you’d like to upgrade to Oracle Database 11.2.0.4 or (very very unlikely hopefully) 11.2.0.3 please see these matching notes:

Some additional things to mention:

SPM is an Oracle Enterprise Edition feature at no

SPM

Some very important MOS Notes when you upgrade and patch

Why do you need patch bundles?

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Your Questions, our Answers for Seminar 2: Upgrade and Performance

The new Oracle 19c Hands-On Lab is available now for download

What you’ll get …

Automatic SQL Plan Management – Slight Change with 19.4.0

Slight Change

Automatic SQL Plan Management in Oracle Database 19c

What is changing in Oracle 19c?

SQL Plan Management – Known Issues in Oracle 12.1.0.2

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts