BE SHARING

Oracle Multitenant

Wrong result with multitenant, dba_contraints and current_schema

23.09.2017 by Oracle Team

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.

Oracle

Active Data Guard services in Multitenant

15.09.2017 by Oracle Team

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

Database management

12c Multitenant Internals: VPD for V$ views

27.06.2017 by Oracle Team

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

Database Administration & Monitoring

Oracle 12cR2: AWR views in multitenant

19.12.2016 by Oracle Team

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

Database Administration & Monitoring

Oracle Database 12c Release 2 Multitenant (Oracle Press)

14.12.2016 by Oracle Team

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

Database Administration & Monitoring

Multitenant internals – Summary

05.12.2016 by Oracle Team

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

Database Administration & Monitoring

12cR2 Single-Tenant: Multitenant Features for All Editions

14.11.2016 by Oracle Team

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

Database Administration & Monitoring

12cR2 multitenant containers in SQL_TRACE

08.11.2016 by Oracle Team

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

Database Administration & Monitoring

Oracle 12cR2 multitenant: Local UNDO

08.11.2016 by Oracle Team

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

Database Administration & Monitoring

Multitenant thin provisioning: PDB snapshots on ACFS

06.09.2016 by Oracle Team

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