I blogged multiple times about DBMS_OPTIM_BUNDLE, the package to work with the Fix Control Persistence (FCP) framework in the database. And we also gave recommendations over the years that you need to test carefully when you are going to enable the fixes while patching. But it is a good practice do enable them when you do upgrade testing, and also when you start creating new databases in a new environment. Just make sure you keep the settings equal across your environments. The other day I received a question from Dennis asking about DBMS_OPTIM_BUNDLE – what it shows, and what oradiff …
Continue reading...DBMS_OPTIM_BUNDLE
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 – 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...New interesting underscores for more than 255 _FIX_CONTROLs
I keep saying this – we have the best and most skilled customers. Christian Klose from my Franconian home region contacted me via LinkedIn and asked for some assistance with an SR. I confess, I replied way too late (information overflow). But the finding Christian had is great to know. There are new interesting underscores for more than 255 _FIX_CONTROLs.
Photo by Casey Horner on Unsplash
Why don’t you see them in ORAdiff?
As usual, I went to ORAdiff and tried to find out anything about these new _fix_control parameters. But I couldn’t find any indication for what Christian …
Continue reading...Patching my environments with the January 2023 Bundle Patches
Mid-of January. It’s patching time again. So let me show you the quarterly exercise of Patching my environments with the January 2023 Bundle Patches. Let’s see this time if I will have to remove my Data Pump Bundle Patch and the 19.17.0 MRP2 at first when I patch in-place.
Photo by karokrasinska on Unsplash
As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home. Please see this blog post about how to apply the RU directly when you provision a new home with OUI…
Continue reading...Patching all my environments with the January 2022 Patch Bundles
It’s patching time. When I checked an SR and had a quick discussion with a customer yesterday, Peter reminded me that it’s patching day. And at about 20:00h CET the new patch bundles appeared on MOS. So let me show you again Patching all my environments with the January 2022 Patch Bundles for 11.2.0.4, 12.2.0.1, 19c and 21c.
Photo by Mehmet Turgut Kirkgoz on Unsplash
As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home. Please see this blog post about how to apply the …
Continue reading...DBMS_OPTIM_BUNDLE and Out-Of-Place Patching
Well, you see, this is most likely my special DBMS_OPTIM_BUNDLE week. And since I receive quite a number of questions, it may be good to discuss here about DBMS_OPTIM_BUNDLE and Out-Of-Place Patching?
Out-of-place Patching
When you patch out-of-place with a new home – which is clearly our recommendation – you may see another tiny pitfall with DBMS_OPTIM_BUNDLE.
When you check DBA_DIRECTORIES, you will find two directories being related to DBMS_OPTIM_BUNDLE.
SQL> select directory_name, directory_path from dba_directories where directory_name like '%OPTIM%' DIRECTORY_NAME DIRECTORY_PATH -------------------- -------------------------------------------------- DBMS_OPTIM_LOGDIR /u01/app/oracle/product/19/cfgtoollogs DBMS_OPTIM_ADMINDIR /u01/app/oracle/product/19/rdbms/admin
You see the “19” in the …
Continue reading...Should you enable _fix_controls with DBMS_OPTIM_BUNDLE?
Today, Paul mailed me asking a question we internally discussed many times in the past weeks: Should you enable _fix_controls with DBMS_OPTIM_BUNDLE? And there is no easy simple answer. But I can give a recommendation based on my experience from many projects.
Photo by paolo candelo on Unsplash
DBMS_OPTIM_BUNDLE – a quick recap
Just in case you haven’t dealt with DBMS_OPTIM_BUNDLE recently, here is a quick recap.
With below procedure, you can list the available potentially behavior changing optimizer fixes in the current patch bundle – and you can turn them on or off at will:
SQL> set serveroutput on;… Continue reading...
Patching all my environments with the July 2021 Patch Bundles
It’s patching day again. Hurray! Or not. I realize that at patching day, the 19c bundles are all missing. So wrote this blog post a bit after the usual release day. In my case this will include Oracle 19.12.0 RU and the July 2021 RU for Oracle 12.2.0.1. Please find the details about Patching all my environments with the July 2021 Patch Bundles below.
Photo by Piron Guillaume on Unsplash
As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home. Please see this blog post …
Continue reading...You may need a one-off for DBMS_OPTIM_BUNDLE in 19.10.0
It’s been a while since I blogged about the DBMS_OPTIM_BUNDLE – and to me, the package is still sort of a mystery. Ideally you can least and enable or disable behavior changing optimizer fixes per RU. And in Oracle 19.10.0, you will find a new surprise. So You may need a one-off for DBMS_OPTIM_BUNDLE in 19.10.0.
Photo by Jonas Denil on Unsplash
Quick Recap
Just in case you haven’t dealt with DBMS_OPTIM_BUNDLE yet or for a while, a quick recap.
With this procedure, you can list the available patches to turn on or off at will:
SQL> set serveroutput… Continue reading...
In case you miss DBMS_OPTIM_BUNDLE … again …?!?
Photo by Caleb Woods on Unsplash
I’m tempted to copy and paste my blog post about DBMS_OPTIM_BUNDLE from February 2019, and exchange only 12.2.0.1 with 19c. But in this case the root cause is different. So this blog post is meant for Oracle 19.3.0 to be precise – in case you miss DBMS_OPTIM_BUNDLE … again … ?!?
Information about DBMS_OPTIM_BUNDLE
You will find a lot of information about DBMS_OPTIM_BUNDLE, what it does, since which release it exists and much more in these blog posts:
DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c
Yes, I did blog about the DBMS_OPTIM_BUNDLE package in earlier Oracle releases before. And I thought (and it was documented this way) that it will disappear in Oracle 12.2 and newer. But in fact you’ll find the DBMS_OPTIM_BUNDLE package in Oracle 12.2 and 18c. Most likely …
This is a very interesting case and you may see also my previous blog posts:
- DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not?
- Fixes for Adaptive Features are included in Oracle 12.1.0.2 October 2017 BP
- Package Differences between Oracle 11.2.0.4 and 12.1.0.2?
DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c
First of …
Continue reading...DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not?
The 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...
