• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » Oracle database 12c: Container Database (CDB) and Pluggable Database (PDB)

Oracle database 12c: Container Database (CDB) and Pluggable Database (PDB)

September 18, 2015 by techgoeasy Leave a Comment

In the last section on Oracle Database 12c, we discussed about the general architecture about Oracle 12c Multitenant Architecture

Multitenant Architecture

Now we will go in more details about.

What is Container Database (CDB) and Pluggable Database (PDB)?

Container Database (CDB) : Container database(CDB) is a main part of Multitenant database .It houses all the things which are shared across all the pluggable database.On the surface this seems very similar to a conventional Oracle database, as it contains most of the working parts you will be already familiar with (controlfiles, datafiles, undo, tempfiles, redo logs etc.). It also houses the data dictionary for those objects that are owned by the root container and those that are visible to all PDBs.
Pluggable Database (PDB) : Pluggable database contains mainly user data. It does not need to worry about controlfiles, redo logs and undo etc as they are managed by Container database. Instead it is just made up of datafiles and tempfiles to handle it’s own objects. This includes it’s own data dictionary, containing information about only those objects that are specific to the PDB.
Data Dictionary in Multitenant Architecture

1)The data dictionary is split ted between  the root container, and PDB.

2) Root container dictionary contains the dictionary of common oracle objects

3) PDB contains the dictionary of its own objects but it can also see the database dictionary of root container

4)  From the perspective of the PDB, the data dictionary is the union of the root and PDB data dictionaries, so internally the PDB feels very much like a normal Oracle database. For example, the DBA_% and ALL_% views within the PDB appears the same as any non-CDB database.

Container Database (CDB)

 

 Related Articles
Top Oracle 12c New Features for developers
Oracle Database 12c:How to Create the container database
Oracle database 12c:How to create Pluggable database in 12c database
Step by Step Oracle 12c Database Installation on Linux
Very useful 10 new things in 12c database
Top 10 oracle 12c new features
Useful Oracle 12c pluggable database commands

Filed Under: Oracle, Oracle Database Tagged With: Container Database (CDB) and Pluggable Database (PDB)

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us