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 : Managing Parameters in Container databases

In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases.

You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same.

The […]

12c Database : How does data dictionary will be shared for multiple databases?

Architecture of Data dictionary in view of multiple containers in a Single SGA

The above diagram requires a explanation.

Data Dictionary

A data dictionary resides in CDB is shared (definitions) between CDB & PDB, for those objects that are system (internal) For example: AWR is global, TAB$, OBJ$ etc.A data dictionary objects or […]

12c: Step by Step 12c GridInfrastructure (RAC) Installation on Linux 64bit

Hello All

Finally able to install the 12c Grid Infrastructure and here is the procedural document. You can download from below link, Also added in downloads link

http://db.geeksinsight.com/wp-content/uploads/2013/07/Step-by-Step-Oracle-12c-Grid-Infrastructure_Installation.docx

-Thanks Geek DBA

12c database architecture

Got this architecture diagram from the internet for 12c database

 

Source:-

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 […]

12c Database: New Features List 2

Few more collection of new features with in 12c database in continuation to my earlier post in this category

RMAN Enhancements:-

Recover or copy files from Standby databases Table level restoration i.e object level Incremental recovery more faster, many of the tasks removed

RAC Enhancements:-

TAF is extended to Transactions failover (insert/update/delete)

Dataguard Enhancements:-

Global […]

12c database Architecture & Some wonderful posts – external links

Hello Readers,

Thanks to Kirill for allowing me to share his blog posts on 12c database. Nice write up where you found the preliminary information on 12c pluggable databases which is coming soon.

Architecture Overview:-

http://www.dadbm.com/2013/01/oracle-12c-pluggable-database-fundamental-architectural-change/

Features Insight:-

http://www.dadbm.com/2013/01/oracle-12c-pluggable-database-feature-insights/

Some hands on:-

http://www.dadbm.com/2013/02/oracle-12c-pluggable-database-pdb-feature-hands-on-experience/

Plug & Unplug the databases in 12c:-

http://www.dadbm.com/2013/02/oracle-12c-pluggable-database-plug-unplug-and-clone/

BTW, I missed to […]

12c Database: OOW Updates

The following may appear in the upcoming release Oracle 12c database.

Architecture in 12c: Multitenant Database , container CDB.

Indexing in 12c: Allows multiple index on same column definition , appealing but not confirmed yet.

Partitioning in 12c: Online move of partition, multiple partition merge in one go, partial indexing, interval reference partitioning

Identity columns […]

12c Database roadmap announced by Larry Ellison

 

WOW!!!! 12C database roadmap announced, as usual it is bringing us a big change in Oracle database architecture.

Oracle Open world started last sunday and Oracle CEO Larry Ellison announced a complete new paradigm architecture of Oracle Database with 12c, which is going to launched in calendar 2013.

From the architecture perspective, this is […]