All Things Database: Education, Best Practices,
Use Cases & More

Oracle Database 12c Release 2 - Capture The Value Of Data With The #1 Database In The Industry

Edgar Haren
Principal Product Marketing Director

          Today, Oracle is proud to announce the general availability of Oracle Database 12c Release 2,  the latest version of the #1 database in the industry for on-premises customers.  A few months ago at Oracle OpenWorld, Oracle announced the latest release of Oracle Database 12c Release 2 (12.2) for the cloud.  This initiative helped Oracle solidify to the market that the company is fully intent on developing the best, enterprise grade, data management solution for deployment on-prem or in the cloud.  The availability of 12.2 in the cloud  also allowed on-premise customers to test-drive the new release while gaining exposure to latest features.  In Oracle’s pursuit to continuously transform data management, innovations focus on scalability, performance, security including the ease of mobility to the cloud.  However the most important innovation of this launch consists of Oracle’s goal of empowering hybrid cloud deployments, and now customers can have the same experience and 100% compatibility whether they run on-premise, in the cloud or both.

Enterprise Scalability, Start-Up Agility And Performance

Oracle Multitenant brings the first major change in the database architecture since the introduction of RAC in 9i. Instead of having a stand-alone database for every application, Multitenant provides a new database consolidation model in which multiple Pluggable Databases (PDBs) are consolidated within a Container Database (CDB). This allows the PDBs to share the memory and background processes of a common CDB, while keeping many of the isolation aspects of single databases. If you are interested in trying out Oracle Multitenant there is a great tutorial available on oracle.com that will step you through all of the different aspects of this new database architecture.

Starting with Oracle Database 12c Release 2 it is now possible to horizontally partition or shard a very large database across a pool of independent databases called shards (up to 1000 shards are supported). Each shard runs on it’s own server and storage, which removes the necessity to have shared storage or clusterware! If you have a large OLTP application that you think could benefit from sharding you can follow the steps outlined in one of the new sharding cookbooks to set up your first sharded Oracle Database!

Oracle Database In-Memory introduces another major change in the database, this time in the form of a new columnar, compressed format and a new In-Memory column store. Up until now the Oracle Database has only stored data in a row format. With the introduction of Database In-Memory, data can now be populated into memory both in a row format (the buffer cache) and a new in-memory optimized columnar format (the column store), simultaneously. The Oracle Optimizer is fully aware of what data exists in the column format and automatically routes analytic queries to the column format and OLTP operations to the row format. It’s extremely easy to begin using Database In-Memory and you can find details here on the getting started posts on the In-Memory blog that walk you through it.

         Lastly, one of the primary design tenets for Oracle Database12c Release 2 was the ability for a customer to run the latest release in their data centers, on Oracle’s public cloud or in a hybrid environment. Providing customers choice, with a range of database services on Oracle Cloud compatible with on-premises environments, is part Oracle’s hybrid cloud strategy, thereby helping customers with their transition to Oracle Cloud. A common architecture and software environment between on-premises and Oracle Cloud facilitates the movement of database workloads, enabling customers to utilize existing skills and resources, and reduce disruptions to their business.  These innovations and product enhancements were put in place to help address customer challenges of today’s environment, but also helping future proof their eventual migration to the cloud.

         We hope you found this blog insightful, and please take a look at the resources below for more information on the value of Oracle Database 12c Release 2 for on-premise deployments, along with the value of Oracle’s Database Cloud Services.


Follow Us On Social Media:



Join the discussion

Comments ( 1 )
  • irfan ahmed khan Thursday, April 6, 2017
    excellent, it this support oracle e-business suite 12.2.5,please share
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.