Video: The New Database Release and Patching Model

The last Office Hours I’ve run about the New Release and Patching Model didn’t go very well technically. I’ve had screen/display issues. And Steven Feuerstein tried to save the best parts – but despite Steven’s awesome work neither him nor I did really like the result. So I decided that it may be better to record a Video: The New Database Release and Patching Model again (which I actually planned for quite a while already anyway. Video: The New Database Release and Patching Model The video is based on the slide deck you’ll find in the Slides download section of…

What does DEPRECATED mean? And DESUPPORTED?

There’s sometimes a misunderstanding about what we mean with the term DEPRECATED? And what is the difference to DESUPPORTED? Actually there’s a full chapter in the Database Upgrade Guide listing deprecated and desupported features. Deprecated and Desupported – Oracle Database 12.1.0.2 Upgrade Guide Deprecated Especially this message puzzled a lot of customers stating that the non-CDB architecture is deprecated in Oracle Database 12c. In the Database Upgrade Guide we clearly explain what deprecated means: “By deprecate, we mean that the feature is no longer being enhanced but is still supported“ So for you it means just be aware that we…

It’s always the Optimizer, isn’t it?! – Part 1

Wouldn’t you agree? My colleagues from the Optimizer Development might forgive me but a lot of people would say: “Everything went fine after upgrade – except for those tiny 3 queries!”. And I know, you have tested a lot. I’d like to tell you about a few issues we’ve seen post upgrade with 11.2.0.2. You have captured your plans in Oracle 10.2 pre-upgrade. You have moved these plans from your SQL Tuning Set into the SQL Plan Baseline in Oracle 11.2. But the optimizer doesn’t pick them although you have: (a) ACCEPTED and (b) FIXED them. Why? It might be…