New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages
«  
  »

12c database architecture

Got this architecture diagram from the internet for 12c database

 

12c_pluggable_database_sSource:-

Some explanation according to my understanding:-

1) Oracle SGA is shared between multiple databases called Pluggable databases (PDB)

2) A root database called container database which holds all the Oracle dictionary globally (CDB) shareable across PDB’s

3) Listener registers both CDB instance and PDB as services

4) There will be

  •       global roles and local roles
  •       local user and common user
  •       common privilege and local privilege

      at CDB level and PDB level, depends on the role setting, the activities (DBA) will be performed accordingly on the local/global database.

5) CDB$ROOT holds oracle data dictionary (assumption)

6) PDB$SEED is the template kind of database for a pluggable database which can be used to create the PDB databases

7) There will be local and global datafiles, as you can see in pink boxes all datafiles that are related to PDB1/2 databases, where there are other files at last in diagram which holds all the global dictionary i.e container database

8) Background processes will be shared across, where in the foreground processes are unique to their databases, this helps to reduce the footprint of processes , Ex: If you have 10 databases in a 11g environment by default 30 BG processes will start, so 30*10 = 300 bg processes, where in 12c cases only 30 BG processes will be used for all 10 databases. User processes i.e foreground anyways depends on the application usability.

Thats all for now, will be adding more once I understand more on this.

-Thanks

Geek DBA

June 22nd, 2013 | Tags: , , , | Category: 12c Database

5 comments to 12c database architecture

  • Vikram
    June 27, 2013 at 11:02 pm

    Hi Geek DBA,

    Looking at the diagram, my first thought was to change my understanding about oracle 🙂 .
    Lot of things coming.

    Regards,
    Vikram

  • Vikram
    June 27, 2013 at 11:57 pm

    Full pack of new features

    1) Single Instance with multiple databases. Oracle Moved from One Database Many Instances(RAC) to Multitenant Acthitecture.
    One Instance Multiple databases.

    2) Only One Home to patch. Sounds Good . But need to bring all the PDB’s Down. As an Applications DBA, was in fix, How to apply
    Application Specific Patches like compatibility patches which are needed for some databases and are not needed for some.
    Further reading might help.

    3) Cloning. Ha Ha, can be done with one command. Create one more PDB from existing one, sounds good.

    4) A new Role CDB Administrator, not a problem, we have moved from database administator, application administrator,
    Middleware administator….

    5) Bothering things is , in oracle documentation they are saying we need less personnel to manage databases, flashes on old joke,
    Oracle will introduce a parameter “is_dba_needed”. With new features ASM,OMF, Automatic Tuning Advisors, AMM and now multitenant databases I think they are moving towards this.

    Geek DBA just an analysis of your diagram and my understanding from Documentation. Correct me If I am wrong.

    Regards,
    Vikram

  • subbu
    July 11, 2013 at 4:25 pm

    Hi,

    Thanks Geek DBA for sharing valuable information in 12C.

    Thanks,
    Subbu