Tech Talk on Oracle Database Multitenant Architecture


Tech-Talks-on-Oracle-Database-1 Tech Talk on Oracle Database Multitenant Architecture

Today we have 2nd guest speaker with us to speak on Oracle Database Multitenant architecture. Being a technology evangelist, technology topics are very close to my heart and especially on Oracle technology. I am just linking back when I have started this podcast back in March 2015, after a few episodes, there were 3 guest speakers with me during Jun 2015 and July 2015 talking on 18 June 2015 – Tech Talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN, 1st July 2015 –13: Oracle Tech Talk on Implementation of Oracle SOA Suite and 12th July 2015 14: Oracle Tech Talk on Implementation of Oracle Database Appliance. All these experts are part of the Oracle ACE Program, community thought leaders and if you want to know about the program, I have also done a podcast session 17 What is Oracle ACE Program. I was also part of the Oracle ACE program prior to joining my current role and being a former Oracle ACE, I have great regard and respect for all the ACE holders as they are the expert, gurus of the field with hands-on expertise driving and leading Oracle Technology in numerous organizations.

Today we have our guest speaker & special thanks to Mir Sayeed Hassan for joining me this week. Until next time!

Today’s Guest

Mir Sayeed Hassan, Oracle ACE Associate, Oracle DBA

What’s one thing you can guide to fresh college graduates for starting a career in technology? Get guidance from our expert who is sharing his knowledge with the community.

You’ll Learn:

Learn from the expert on Oracle Multitenant architecture for the next-generation database

Oracle Database Multitenant Architecture and tips based on the speaker’s experience. The Multitenant architecture allows a single container database i.e “CDB” & multiple other containers Pluggable databases i.e “PDB”.

  • Container Database (CDB): The primary database that contains multiple plugged-in databases. Many operations can be performed at the container level to reduce management costs. 
  • Seed Database (Seed PDB): A default PDB that the system uses as a template to quickly provision other user-created PDBs. 
  • Pluggable Database (PDB): PDBs are user-created and will be used to hold the business-related data, therefore the number of PDBs that can be held is 253 in 1 Single Container Database.

Topics discussed such as:

  • Overview of Pre-12c Version of Database
  • Overview of Oracle Multitenant Architecture of CDB & PDBs
  • Core Components of a Multi-tenant Database 
    • CDB Instance
    • Root Container (CDB$ROOT)
    • Seed Container (PDB$SEED)
    • Pluggable Database (PDBs) 
  • Unplugging and Plugging in Pluggable Databases (PDBs) 
  • Refreshable Pluggable Database (PDB)
  • Relocate a Pluggable Database (PDB)
  • Common Entities between CDB and PDBs

Resources:

Thanks for Listening!

To share your thoughts:

  • Leave a comment on the section below on this post
  • You want to suggest any new topic we should cover in future Podcast
  • Join us in Mastermind tribe
  • Share this on TwitterFacebook, If you enjoyed this episode and we together are learning new Technologies.

To help out this initiative:

  • Leave a candid review for the OTechTalks Podcast on iTunes! Your ratings and reviews will help the session on iTunes.
  • Subscribe to the Podcast on iTunes to get next sessions