Real ODA “one button patching”, 12.1.2.6 to 12.1.2.10

Jun 19, 2017

Today I had to patch a virtualized Oracle Database Appliance X5-2 HA at a customer site. Current version was 12.1.2.6, installed in June 2016, and it had to be upgraded to 12.1.2.10. I’ve heard a lot of scary stories of colleagues and friends about possible issues during patching, so I was a little reluctant to do this. Anyway, no choice, what needs to be done, needs to be done.

I had one big advantage: this ODA was installed by myself and I was 100% sure that nobody had ever done something ‘unsupported’ with it. During installation in June 2016, I have taken very much care about following the books accurately and ensuring that nothing went wrong. This was a real clean install without any issues, now in production for 1 year.

Now one year later I have to say that I am very happy with “my ODA”. The patching today went smoothly. Not a single issue was encountered during the patching. Actually I was a little surprised, because as I said, I have heard about many issues of others during patching. Read the rest of this entry »


Why DB_BIG_TABLE_CACHE_PERCENT_TARGET was a good solution in my case

May 12, 2017

During the preparation of my Oracle DBA 12c Certified Master exam, I learnt about the DB_BIG_TABLE_CACHE_PERCENT_TARGET parameter in 12c. This parameter allows you to reserve a certain percentage of the buffer cache for storing large tables. You know that full table scans on large tables are normally NOT stored in the buffer cache (they also use direct reads, bypassing the buffer cache), because it should not be the intention to keep scanning large tables over and over again.

Read the rest of this entry »


Improve the world, start with yourself.

Jan 31, 2008

Today I wanted to open a Metalink SR for a high availability problem (in a RAC + Dataguard environment), and guess what I got.

It seems like theory is still different from practice.


The Oracle Enterprise Linux story of the master himself: Wim Coekaerts

Jan 25, 2008

Yesterday I had the uniqe opportunity to attend a Q&A session with Wim Coekaerts, the father of the whole linux story within Oracle. I agree completely with what Freek already posted in his blog (he attended as well). On top of that I want to add some personal thoughts as well. Read the rest of this entry »


It’s my turn to tell 8 things about myself

Jan 14, 2008

I was tagged by Freek so I’ll do what is expected from me.

Read the rest of this entry »