Somebody asked me the other day why the download options for Oracle Database 12.1.0.2 for Linux and Solaris disappeared from OTN? The same will happen with the...
Somebody asked me the other day why the download options for Oracle Database 12.1.0.2 for Linux and Solaris disappeared from OTN? The same will happen with the other platforms as soon as Oracle Database 12.2.0.1 is available on-premises for them as well. You can always download Oracle Database 12.1.0.2 and previous releases from: Oracle Software Cloud (eDelivery). --Mike
Somebody asked me the other day why the download options for Oracle Database 12.1.0.2 for Linux and Solaris disappeared from OTN? The same will happen with the other platforms as soon as...
The new version of the preupgrd.sql (including the utluppkg.sql package) in its February 2017 version is available for download from MOS Note:884522.1. If you...
The new version of the preupgrd.sql (including the utluppkg.sql package) in its February 2017 version is available for download from MOS Note:884522.1. If you are going to upgrade to Oracle Database 12.1.0.2 please exchange your current preupgrd.sql/utluppkg.sql either in ?/rdbms/admin or in the location of the source system you've copied it to with the new version. . --Mike.
The new version of the preupgrd.sql (including the utluppkg.sql package) in its February 2017 version is available for download from MOS Note:884522.1. If you are going to upgrade to Oracle Database...
New Parameters in Oracle Database 12.1.0.2 with July 2016 PSU/BP By following an internal discussion and checking parameter changes between Patch Set Updates...
New Parameters in Oracle Database 12.1.0.2 with July 2016 PSU/BP By following an internal discussion and checking parameter changes between Patch Set Updates (PSU) and Proactive Bundle Patches (BP) I learned that we introduced two new SPFILE parameters in Oracle Database 12.1.0.2 with the July PSU and BP. One is documented in the patch readme, the other one can be found right now only in the Oracle Database 12.2.0.1 manual: ALLOW_GROUP_ACCESS_TO_SGA ENCRYPT_NEW_TABLESPACES...
New Parameters in Oracle Database 12.1.0.2 with July 2016 PSU/BP By following an internal discussion and checking parameter changes between Patch Set Updates (PSU) and Proactive Bundle Patches (BP)...
Oracle Database 12.2 introduces the new split-up adaptive parameters, OPTIMIZER_ADAPTIVE_PLANS and OPTIMITER_ADAPTIVE_STATISTICS. For more information please...
Oracle Database 12.2 introduces the new split-up adaptive parameters, OPTIMIZER_ADAPTIVE_PLANS and OPTIMITER_ADAPTIVE_STATISTICS. For more information please see: https://blogs.oracle.com/UPGRADE/entry/optimizer_adaptive_features_obsolete_in https://blogs.oracle.com/optimizer/entry/optimizer_adaptive_features_in_the But Oracle Database 12.2 on-premises is not out yet - so what should you do when upgrading to Oracle Database 12.1 - or struggling with some of the "adaptive"...
It's so funny - for years I discuss with customers minimal downtime upgrade strategies back and forth, up and down. I saw DBAs really hunting to save a few...
It's so funny - for years I discuss with customers minimal downtime upgrade strategies back and forth, up and down. I saw DBAs really hunting to save a few seconds potential downtime - and I always take this serious as there is usually a real reason behind that. Just to learn a few days later by repeating experience that my work Windows7 laptop goes down to apply upgrades ... and this takes looooooooong .... sometimes it takes a lengthy +30 minutes of quiet time. Whereas my...
It's so funny - for years I discuss with customers minimal downtime upgrade strategies back and forth, up and down. I saw DBAs really hunting to save a few seconds potential downtime - and I...
Parameter Recommendations for Oracle Database 12c - Part I ==> Parameter Recommendations for Oracle Database 12c - Part II Time for a new round on Parameter...
Parameter Recommendations for Oracle Database 12c - Part I ==> Parameter Recommendations for Oracle Database 12c - Part II Time for a new round on Parameter Recommendations for Oracle Database 12.1.0.2. The focus of this blog post settles on very well known parameters with interesting behavior. This can be a behavior change or simply something we'd like to point out. And even if you still work on Oracle Database 11g some of the below recommendations may apply to your...
Parameter Recommendations for Oracle Database 12c - Part I ==> Parameter Recommendations for Oracle Database 12c - Part II Time for a new round on Parameter Recommendations for Oracle Database...
==> Parameter Recommendations for Oracle Database 12c - Part I Parameter Recommendations for Oracle Database 12c - Part II A few weeks ago we've published some...
==> Parameter Recommendations for Oracle Database 12c - Part I Parameter Recommendations for Oracle Database 12c - Part II A few weeks ago we've published some parameter recommendations including several underscores but based on an internal discussion (still ongoing) we decided to remove this entry and split up the tasks. The optimizer team will take over parts of it and I'll post an update as soon as something is published. . Preface Please be advised - the following...
==> Parameter Recommendations for Oracle Database 12c - Part I Parameter Recommendations for Oracle Database 12c - Part II A few weeks ago we've published some parameter recommendations including...
Two weeks ago I published a blog post about Parameter Recommendations for Oracle Database 12.1.0.2. And I took it down a day later. Why that? I've got a lot of...
Two weeks ago I published a blog post about Parameter Recommendations for Oracle Database 12.1.0.2. And I took it down a day later. Why that? I've got a lot of input from external sources for the "Parameter" blog post. And I'd like to thank everybody who contributed to it, especially Oracle ACE Ludovico Caldara. Generally there was a bit of a misunderstanding internally about whether we should "advertise" underscore parameters to cure some misbehavior of the database. In 99%...
Two weeks ago I published a blog post about Parameter Recommendations for Oracle Database 12.1.0.2. And I took it down a day later. Why that? I've got a lot of input from external sources for the...
Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2: Sept 17, 2015:SE2 - Some questions, some answers Sept 8, 2015:MOS Download for...
Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2: Sept 17, 2015:SE2 - Some questions, some answers Sept 8, 2015:MOS Download for Oracle SE2 Sept 7, 2015:Support and Patches for Oracle 12.1.0.1 SE/SE1 Sept 3, 2015:Can you have Multitenant with Oracle SE2? Sept 1, 2015:Oracle Standard Edition SE2 available for download You have 3 options to download Oracle Database Enterprise Edition 12.1.0.2 and Oracle Database Standard Edition 12.1.0.2. SE2....
Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2: Sept 17, 2015:SE2 - Some questions, some answers Sept 8, 2015:MOS Download for Oracle SE2 Sept 7, 2015:Support and...
