Oracle Multitenant

Wrong result with multitenant, dba_contraints and current_schema

By Franck Pachot . Multitenant architecture is not such a big change and this is why I recommend it when you start a project in 12c or if you upgrade to 12.2 - of course after thoroughly testing your application.

Active Data Guard services in Multitenant

By Franck Pachot . A database (or the CDB in multitenant) registers its name as the default service. When a standby database is on the same server, or same cluster, you have no problem because this database name is the(…)

12c Multitenant Internals: VPD for V$ views

By Franck Pachot . I described in an earlier post on AWR views how the dictionary views were using metadata and object links to show information from other containers. But this mechanism cannot work for fixed(…)

Oracle 12cR2: AWR views in multitenant

By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object(…)

Oracle Database 12c Release 2 Multitenant (Oracle Press)

By Franck Pachot . Here it is. The multitenant book is out for sale...

Multitenant internals – Summary

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(…)

12cR2 Single-Tenant: Multitenant Features for All Editions

By Franck Pachot . Now that 12.2 is there, in the Oracle Public Cloud Service, I can share the slides of the presentation I made for Oracle Open World:(…)

12cR2 multitenant containers in SQL_TRACE

By Franck Pachot . In multitenant you session can switch between containers. For example, since 12.1, a common user can switch explicitly between CDB$ROOT and any PDB with the 'ALTER SYSTEM SET CONTAINER'. Any user connected to a PDB will(…)

Oracle 12cR2 multitenant: Local UNDO

By Franck Pachot . Pluggable Databases are supposed to be isolated, containing the whole of user data and metadata. This is the definition of dictionary separation coming with multitenant architecture: only system data and metadata are at CDB level. User(…)

Multitenant thin provisioning: PDB snapshots on ACFS

By Franck Pachot . Database on ACFS is a long story. At first, the main reason for ASM was to bypass a filesystem layer that is not required by the database. ACFS was for the non-database files that had to(…)