PART1-12c Database What is MultiTenant Architecture and Its Benefits PLuggable and Container Databases   3 comments

In this post I am going to give an overview of 12c Database New Feature called Multitenant Database:

What is Multitenant Architecture?  

This feature allows you to create and maintain many pluggable databases within an multitenant container database.

Multiple tenants share same resources on a mutual benefit for different purposes at a very broad level. The same applies to Oracle Database where Multiple Databases share a single instance of resources aiming for different purposes on the same Server. This Oracle Database which is built on Multitenant foundation is called Container Database(CDB), and each container(tenant) residing inside is called Pluggable Database(PDB, Container).

PGD

A multitenant container database (CDB) is defined as a database capable of housing one or more pluggable databases. A container is defined as a collection of data files and metadata that exist within a CDB. A pluggable database is a special type of container that can be easily provisioned by cloning another database. If need be, a pluggable database can also be transferred from one CDB to another.

Every CDB contains a master set of data files and metadata known as the root container. Each CDB also contains a seed container, which is used as a template for creating other pluggable databases. Each CDB consists of one master root container, one seed container, and zero, or one or more, pluggable databases.

Benefits:-

One of the main reasons for Multitenant Architecture is to have “Database Consolidation”.

Till now we have databases deployed across multiple Small Physical machines on various platforms. It could be waste of resources having a database on each machine dedicatedly rather keeping them all on a single powerful machine. By consolidating all Databases onto a Single powerful chip and a Single Oracle Instance, we achieve following benefits:

Cost reduction in terms of Product licensing and Hardware procurement as we require less number of processors and less memory compare to a Non-CDB environment

Easier Database maintenance, Pluggable Databases can easily be moved or copied locally or remotely across Physical machines in the network, Upgrading Operating System, Upgrading or Patching Database itself is a lot easier and “often” a one shot process, that greatly improves the availability

Performance tuning becomes a lot easier as all PDBs in a CDB environment share same Hardware/Platform/Network resources like CPUs/Memory/OS/Bandwidth etc.. For example, It is quite easy to tune one single piece of SGA/PGA on one single instance rather tuning each SGA on each physical machine

—In my next post I will provide the details about 12c Installation and Creating Container Database, Also i will include  Steps for Creating Pluggable Database  in Container Database.

Advertisements

Posted October 9, 2013 by balaoracledba.com in 12cDatabase, Oracle DBA

3 responses to “PART1-12c Database What is MultiTenant Architecture and Its Benefits PLuggable and Container Databases

Subscribe to comments with RSS.

  1. Can anyone provide me Interview
    questions & answers on specific
    topic till RMAN..
    All Scenarios of loss of CRD files
    without backup & with backup what
    happen internaly.
    please share Ahmermohiuddin@
    live.com

  2. Can anyone provide me Interview
    questions & answers on specific
    topic till RMAN..
    All Scenarios of loss of CRD files
    without backup & with backup what
    happen internaly.
    please share it Ahmermohiuddin@
    live.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: