Adaptive Execution Plans – not available in Oracle SE2

I received an interesting question on the blog the other day: “Are Adaptive Plans an Enterprise Edition only feature?” What does the License Guide say? The Oracle Database 12.2 License Guide says: What does www.oracle.com say? This is the link the customer came across – also saying that Adaptive Execution Plans are an Enterprise Edition only feature: What does this mean for SE2? That is the question Adam had. Does this impact SE2? Will I get an error or – even worse – a license violation if I have optimizer_adaptive_plans=TRUE – which is the default? No, none of it will…

SE2 – Some questions, some answers …

*** Updated on Nov 6  to reflect 11.2.0.4 changes*** There were a lot of questions regarding Oracle Database Standard Edition 12.1.0.2 SE2 in the past days. See below for further blog posts on SE2. And please find the official Oracle SE2 “brief” document here giving you a good overview on SE2: http://www.oracle.com/us/products/database/oracle-db-se2-brief-2680836.pdf I’ll try to summarize some topics I’m able to answer by myself. And please don’t expect me to assist with license or license migration questions – that is far beyond my scope or knowledge or responsibility, and you may please contact your Oracle sales person regarding these topics…

MOS Download for Oracle Database 12.1.0.2 including 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 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. OTN – Oracle Technology Network eDelivery – Oracle Software Delivery Cloud MOS – MyOracle Support https://updates.oracle.com/download/21419221.html Regarding OTN and eDelivery nothing has been…

Oracle Database 12.1.0.2 SE2 – Support and Patches for Oracle Database 12.1.0.1 SE/SE1

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   Some questions regarding support for Oracle Database Standard Edition 12.1.0.1 (SE/SE1) came up in the past days. Most of those are answered already in MOS Note 2027072.1 (Oracle Database 12c Standard Edition 2 (12.1.0.2) ) How long will Oracle Database 12.1.0.1…

Oracle Database 12.1.0.2 Standard Edition (SE2) available for download

Finally … Oracle Database 12.1.0.2 Standard Edition (SE2) is available for download. Some information is already available in the Oracle Database Licensing Information. And you’ll find more here: https://www.oracle.com/database/standard-edition-two/index.html Quoting from the pricing document: http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf “Oracle Database Standard Edition 2 may only be licensed on servers that have a maximum capacity of 2 sockets. When used with Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be licensed on a maximum of 2 one-socket servers. In addition, notwithstanding any provision in Your Oracle license agreement to the contrary, each Oracle Database Standard Edition 2 database may use a maximum of…