Select Sidearea

Populate the sidearea with useful widgets. It’s simple to add images, categories, latest post, social media icon links, tag clouds, and more.
Oracle Database

What are the differences between 11g and 12c Oracle Database?

Oracle Database

As a provider of the combined package service Oracle DB Management and Oracle Gold Partner we are often asked: What are the main differences between 11g and the newest 12c Oracle Database.


You ask, we answer! Here are the main features of 12c that differ it from 11g:


The major innovation is the multi-tenancy database.  That lets you share common infrastructure between multiple databases. Those are called “pluggable database”. They are “plugged” into a “container” database, which manages the resources.  The main purpose of this approach is to make it possible to run many databases on the same hardware. At the same time, you maintain complete security and isolation between the databases. This approach is ideal for cloud deployment.


Here are some of the rest new features of 12c compared to 11g:


1.Multiple indexes


Before Oracle users were able to create a single index on one column. With Oracle 12c users can create multiple indexes on the same column. However, the index type must be different and only one type of index is visible at a given time.


2.Invisible columns


Oracle 12c introduces new feature of invisible columns in the table. When a user defines a column as invisible, it won’t appear in generic queries, unless the column is explicitly referred to in the SQL statement or condition, or described in the table definition. However, temporary tables, external tables and cluster tables won’t support invisible columns.


3.In-memory aggregation


Oracle 12C supports In-memory aggregation, which optimizes the queries that joins the dimension tables to fact tables and aggregate data. User needs to use KEY VECTOR and VECTOR GROUP BY operations to achieve the In-memory aggregation. In memory, aggregation is used in star schema, which improves the performance of Star queries and reduces the CPU usage. The In-memory aggregation eliminates the need of summary tables in most of cases which simplifies the star schema query.


4.JSON Support


This feature adds support for storing, querying and indexing JavaScript Object Notation (JSON) data to Oracle Database. It allows the database to enforce that JSON stored in the Oracle Database conforms to the JSON rules. This feature also allows JSON data to be queried using a PATH based notation and adds new operators that allow JSON PATH based queries to be integrated into SQL operations.


5.Automatic Big table caching:


In previous versions of Oracle, in-memory parallel query did not work well when multiple scans contended for cache memory. The new cache mechanism called big table cache is used to improve the performance for full table scan.


6.Full Database caching:


Caching the entire database provides significant performance benefits, especially for workloads that were previously limited by I/O throughput or response time. More specifically, this feature improves the performance of full table scans by forcing all tables to be cached. This is a change from the default behavior in which larger tables are not kept in the buffer cache for full table scans.


Contact us for additional information and a FREE consultation!

contact us
  • Posted at 8:42 pm, 08/05/2019

    I am not sure where you are getting your information, but great topic.
    I needs to spend some time learning much more
    or understanding more. Thanks for great information I was looking for
    this info for my mission.

  • Posted at 4:25 am, 09/05/2019

    I love your blog.. very nice colors & theme. Did you design this website yourself or did you hire someone to do it for you?
    Plz reply as I’m looking to create my own blog and would like to find out where u got this from.
    appreciate it

  • Posted at 6:08 pm, 04/06/2019

    It is really a nice and helpful piece of information. I’m glad that you simply shared this useful info with us. Please keep us up to date like this. Thanks for sharing.

  • Posted at 12:41 am, 18/06/2019

    It is really a nice and useful piece of
    info. I’m happy that you simply shared this useful info with us.
    Please stay us up to date like this. Thanks for sharing.

  • Posted at 12:20 pm, 22/06/2019

    Quality content is the secret to be a focus for the viewers to go to see the website, that’s what this web site is providing.

  • Posted at 5:20 pm, 25/06/2019

    Your mode of describing all in this paragraph is genuinely fastidious, all be capable of effortlessly know it, Thanks
    a lot.

  • Posted at 2:15 am, 26/06/2019

    I appreciate you sharing this blog post.Much thanks again. Will read on…

Post a Comment