OracleNotes

Category: Database

  • Oracle Database 18c

    Happy New Year 2018!

    We all have questions on Oracle Database 18c and its ability to self-drive! I tried to summarize my understanding of Oracle Database 18c and RU/RUR in a blog post here.

    What to expect in Oracle Database 18c

    “Oracle Database 18c by itself is NOT Self-Driving. It is the Oracle Autonomous Database Cloud Service that brings the “Self-Driving” in 18c. Oracle Database 18c installed on-prem will “drive” pretty much the same as Oracle Database 12c.”

    I like the idea of releasing major features more frequently and releasing patches and updates that are smaller in size and easy to test. But, the question still is how many DBAs out there are ready to patch every quarter, even if you are able to automate the patching using OEM and other tools.

  • Adaptive Query Performance Fixes for #DB12c Release 1

    We all know adaptive query feature introduced in Oracle Database Release 1 is a problem. Recently I had the opportunity to review few 12cR1 databases and found that to alleviate the performance problems, the DBA set parameter OPTIMIZER_FEATURES_ENABLE=11.2.0.4 in Oracle Database 12c Release 1 (12.1.0.2). This observation is the catalyst for the blog “Adaptive Query Patches in Oracle Database 12c Release 1” on my Company Blog.  Oracle Support team provided options to turn off the new feature (OPTIMIZER_ADAPTIVE_FEATURES=FALSE) or to fix the issues with a Proactive Bundle Patch or with a one-off patch. Please read the blog to find out the options DBA have to fix the adaptive query optimization problem in Oracle Database 12c Release 1.