Differences between PSU / BP and RU / RUR

Since Oracle Database 12.2.0.1 we change our patching model as well, switching from Patch Set Updates (PSU) and Proactive Bundle Patches (BP) to Release Updates (RU) and Release Update Revisions (RUR). But what are actually the differences between PSU / BP and RU / RUR patch bundles? Is there any or is it just a renaming of well known patch bundles?… [Read More]

Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases

How often did I launch a search in MyOracle Support (MOS) for a specific Bundle Patch or Patch Set Update. And usually the MOS search results don’t get me what I’m looking for no matter how clever I search. But there was relief. A MOS Note combined all PSUs and BPs and much more into table format including the links.… [Read More]

_rowsets_enabled – Apply patch and use the default

I while back I blogged about issues with “rowsets“, a new Oracle 12c feature which unfortunately had two known wrong result (WQR) bugs:

Switch off “_rowsets_enabled” in Oracle Database 12c

UPDATE: _rowsets_enabled in Oracle Database 12c

What does “rowsets” actually mean?

I’d like to thank Sankar, our Development manager for providing this explanation which sheds some light on how important this feature actually is:

“Rowsets is a SQL execution performance enhancement introduced in Oracle RDBMS release 12.1 and further extended in a future release of the Oracle Database.

[Read More]

Patching does not work – Journey to the Cloud VI

What happened so far on my Journey to the Cloud?

DBaaS Oracle Cloud

Patching in the Cloud

I would like to patch my Oracle DBaaS Cloud today.… [Read More]

Switch off “_rowsets_enabled” in Oracle Database 12c

Please find a recent update here:

UPDATE: _rowsets_enabled in Oracle Database 12c

and more important:

_rowsets_enabled – Apply patch and use the default


Twitter is a good thing. I get alerted on things I haven’t seen before. And sometimes some things are more than interesting.

This one is actually proven by Jonathan Lewis – and you can read all the details in Jonathan’s blog post here:

There seems to be a realistic chance to get wrong query results displayed (regardless of using SQL*Plus or a JDBC or any other client – see the comment by Stefan Koehler below Jonathan’s posting) because of the row sets feature in Oracle 12.1 allowing faster initial processing of query results.… [Read More]

Oracle PSU and BP April 2015 is available

As of April 14, 2015:

The April 2015 PSU/BP is available!

Here’s the most important information:

[Read More]