By Franck Pachot

.
Today at UKOUG TECH16 conference I’m presenting the internals of the new multitenant architecture: 12c Multitenant: Not a Revolution, Just an Evolution. My goal is to show how it works, that metadata links and object links are not blind magic.
Here are the links to the blog posts I’ve published about multitenant internals.

Fichier 05.12.16 07 39 43
The dictionary separation, METADATA LINK and OBJECT LINK (now called DATA LINK): :
http://dbi-services.com/blog/multitenant-dictionary-what-is-stored-only-in-cdbroot/
http://dbi-services.com/blog/oracle-12c-cdb-metadata-a-object-links-internals/
http://dbi-services.com/blog/oracle-multitenant-dictionary-metadata-links/
http://dbi-services.com/blog/oracle-multitenant-dictionary-object-links/
http://dbi-services.com/blog/multitenant-internals-how-object-links-are-parsedexecuted/
http://dbi-services.com/blog/multitenant-internals-object-links-on-fixed-tables/
An exemple with the AWR views:
http://dbi-services.com/blog/12c-multitenant-internals-awr-tables-and-views/
How the upgrades should work:
http://dbi-services.com/blog/oracle-multitenant-dictionary-upgrade/
What about shared pool rowcache and library cache:
http://dbi-services.com/blog/oracle-multitenant-dictionary-rowcache/
http://dbi-services.com/blog/12c-multitenant-cursor-sharing-in-cdb/
And how to see when session switches to CDB$ROOT:
http://dbi-services.com/blog/oracle-12cr2-multitenant-containers-in-sql_trace/
Added later, the V$ views using VPD-like row level security
https://www.dbi-services.com/blog/12c-multitenant-internals-vpd-for-v-views/
More about PDB replay DDL for common users and pdb_plug_in_violations:
https://www.dbi-services.com/blog/12c-multitenant-internals-pdb-replay-ddl-for-common-users/
https://www.dbi-services.com/blog/12c-multitenant-internals-pdb_plug_in_violations/

If you are in Birmingham, I’m speaking on Monday and Wednesday.

CaptureUKOUGFeaturedSpeaker