one-off

DBMS_JOB one-off patch needed for Oracle 19.3.0 – 19.7.0

Posted on May 21, 2020 by Behavior Change Patch Recommendation 10

A while ago I blogged already about this behavior change for DBMS_JOB in Oracle Database 19c. Many of you are aware of this. But today I learned something new about it. Kudos to Alexey Makhmutov for bringing this to my attention. There is a very important fix you will need on top in 19c to avoid performance issues. If you rely on jobs with the old job interface, take note: DBMS_JOB one-off patch needed for Oracle 19.3.0 – 19.7.0

DBMS_JOB one-off patch needed for Oracle 19.3.0 - 19.7.0

Photo by Christopher Burns on Unsplash

What is the problem?

As you can read from there is a internal …

Continue reading...

The newest patching surprises – and how to fix some of them

Posted on September 4, 2019 by Patch Recommendation 19

Well, there is no Product Manager for patching. And I’m glad that I’m not in this position. But thanks to all of you, internally and externally, who share your findings with me. In this blog post I’d like to inform you about the newest patching surprises – and how to fix some of them.

The newest patching surprises - and how to fix some of them

Patch apply without confirmation?

Peter Lehmann informed me about this a few weeks ago. Peter told me that he patched systems with the July 2019 RU for Oracle 12.2.0.1 and recognized that the patch installed with opatch without waiting for confirmation. It looked as somebody has …

Continue reading...

Archives

Categories

Upgrade @YouTube

Blog Stats

  • 44,615
  • 181,714
  • 2,154,694
  • 448,844
  • 1,004

Subscribe via Email

Join 4,766 other subscribers

Follow me on Twitter