Oracle 12c Pluggable Database is a fundamental architectural change

January 18, 2013 by 9 Comments 

Oracle 12c Pluggable Database Architecture

Oracle 12c Pluggable Database Architecture

With a new Oracle 12c database release Oracle is going to come up in 2013 with a fundamentally new architecture called Pluggable Database that will greatly help enterprises in data and database consolidation as well in building a foundation for Private Database Clouds. Traditionally Oracle had several databases for several applications. Oracle 12c database will enhance its consolidation ability and will allow multiple customers data to coexist in a single database. Since 12c will be released pretty soon, I’d like to share some details on 12c Pluggable Database feature.

With 12c Pluggable Database feature Oracle will introduce a notion of a container database (CDB). This container will hold some number of Pluggable databases (PDB). So, as a result you will have one dedicated database instance (or several ones in case of Oracle RAC) and you will be able to create or plug multiple private databases into this single container. RDBMS will be responsible for keeping those databases separate, private and secure. Pluggable Databases should be more efficient in terms of resource consumption, scalability and manageability (see the Oracle comparison graph) compared to a single database. Based on Oracle show case, it will consume 6 times less hardware resources and will be 5 times more scalable. One can backup all of PDBs at once and will be able to restore any of them at any time. This new technology will be transparent to applications and all Oracle database features should work for Pluggable Private databases.

Oracle 12c Pluggable Database vs separate database

Oracle 12c Pluggable Database vs separate database

Oracle 12c Pluggable Database vs. Microsoft SQL Server database

Microsoft SQL Server 2005 architecture

Microsoft SQL Server 2005 architecture

At Oracle Open World 2012 in San Francisco some folks said 12c Pluggable Database feature would be a revolution architecture change. And in a way it’s true, but only in the Oracle world. I think that Oracle is just catching up in this case with Microsoft SQL Server which has been demonstrating the value of its private database concept in practice for decades. The following figure shows the encapsulation of instances, databases, schemas, and objects in SQL Server 2005, but I remember that private databases concept was already present in version 2000.

But let’s come back to our Oracle 12c Pluggable Databases…

12c Pluggable Database feature benefits

– Consolidate many PDBs onto a single platform.

– Fast provisioning of a new PDB or of a clone of an existing PDB;

– Fast redeployment, by unplug and plug, of an existing database to a new platform

– Patch or upgrade the Oracle Database version for many PDBs quickly by doing it just once

– Patch or upgrade a single PDB by unplugging it and plugging it into a different CDB at a later version

– Separation of the content of one PDB from that of peer PDBs in the same CDB

– Separation of the duties of the application administrators of these PDBs

12c Pluggable Database feature capability

– You can have many Pluggable Databases (PDBs) inside a single container database (CDB)

– PDB is backwards compatible with an ordinary pre-12.1 database;

– PDB is transparent to applications – you don’t change the client code or your database objects

– Each instance in a RAC opens CDB as a whole (so the CDB and all the PDBs in it are at the same Oracle Database version)

– A session sees only the single PDB it connects to

– You can unplug a PDB from one CDB and plug it into another CDB

– You can clone a PDB, both within the same CDB or from one CDB to another one

– Resource Manager is extended with new PDB capabilities

– The operations on PDBs as entities (creating, unplugging, plugging in, cloning, dropping, and setting the Open_Mode) are implemented as SQL statements

– CDB’s administrator executes these operations when connected to its so-called root

– Pluggable Databases functionality is fully interoperable with all the database options

– All PDBs can be backed up at once, but recovered separately

I’ll continue in the next article giving more details about Pluggable Database feature in the next posts…

Enjoyed this article? Please share it with others using the social site of your choice:

Comments

9 Responses to “Oracle 12c Pluggable Database is a fundamental architectural change”
  1. Kyle Hailey says:

    Excited about the pluggable database functionality. Pluggable databases will make cloning an Oracle database practically free. Delphix clones have a near zero cost at the storage level (because Delphix clones share the bulk of datablocks) but now with 12c there will be near zero cost at the memory level. On top of that Delphix clones can share all the memory caching on Delphix allowing the data block cache in the database container to be kept at a minimum.
    For more info see http://dboptimizer.com/2013/01/16/delphix-live-webcast-realize-massive-roi-with-database-virtualization/
    More information to come soon

    – Kyle Haiely

  2. Kirill Loifman says:

    Hi Kyle
    Always nice to see you here. I’ll try to join also.
    — Kirill

  3. ramesh says:

    Hi…..Its really knowledgeable ….keep it up

    Regards
    \\vinayak

  4. Buck O'rogers says:

    Nice to see you both. Looking forward to more info. This is such an exciting development!

  5. Jatin Gulati says:

    Hello Mr. Loifman, is it possible to share the 12c dowloadable link for testing purpose.
    Thanks,

  6. Kirill Loifman says:

    Sorry, only Oracle can share its software downloads
    — Kirill

  7. Tnx from Italy.

    Your lessons about Oracle 12c are very precious. I will follow your blog

  8. Azim says:

    Hi Kirill

    Thanks for sharing this nice post.

    I have one question.
    Is this 12c pluggable database feature has any resemblance with SQL server attaching and detaching of databases?

    –Azim

  9. Kirill Loifman says:

    Yes Azim, you are right it’s similar but has different naming and some advantages.
    For example, ONLINE cloning of a database should be possible in the final release of Oracle 12c.
    And I do not think it’s an option in SQL Server.
    — Kirill

Add a Comment

We welcome thoughtful and constructive comments from readers.
If you want your own picture to show with your comment?
Go get a Globally Recognized Avatar!

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email