datapatch -verbose

How to speed up datapatch – and much more information

Posted on May 30, 2022 by Mike.Dietrich Patch Recommendation 18

Ok, I promised to write more about patching speed. And this blog post will be just the root post targeting datapatch speed. I will link also to blog posts I’ve written before but also share knowledge which may not be obvious at first stage. The overall topic will be How to speed up datapatch – and much more information.

How to speed up datapatch - and much more information

Photo by National Cancer Institute on Unsplash

What is datapatch

Let me start at the ground level and explain what datapatch is and why it exists.

When you are still on Oracle Database 11g, you may wonder what datapatch …

Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0

Posted on March 2, 2021 by Mike.Dietrich Flaws and Pitfalls 6

The other week a customer from my hometown alerted me about an issue they saw when applying the 19.9.0 RU. A long sequence of errors in the datapatch run, all of them signaled from sdoloadj.sql. They opened an SR. And Support had an – understandable – recommendation the customer didn’t want to implement: Install JAVAVM. But thanks to my PM mate, Hans Viehmann (Mr Spatial), here is a simple Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0. And it may even apply to later releases, too.