BE SHARING

internals

12c Multitenant internals: PDB_PLUG_IN_VIOLATIONS

30.12.2017 by Oracle Team

By Franck Pachot . In the previous post https://www.dbi-services.com/blog/12c-multitenant-internals-pdb-replay-ddl-for-common-users I've done some DDL on a common user to show how this is replayed later for PDBs that were not opened at that time. But what happens(…)

Oracle

12c Multitenant internals: PDB replay DDL for common users

29.12.2017 by Oracle Team

By Franck Pachot . In multitenant, you can create common Users, Roles, and Profiles. You create them in CDB$ROOT, with the CONTAINER=ALL clause (which is optional because it is the only possible value when connected to CDB$ROOT) but they are(…)

Oracle

Multitenant internals: INT$ and INT$INT$ views

05.11.2017 by Oracle Team

By Franck Pachot . This month, I'll talk - with lot of demos - about multitenant internals at DOAG conference. The multitenant dictionary architecture starts with a simple idea: system metadata and data are(…)

Oracle

Multitenant dictionary: what is consolidated and what is not

05.11.2017 by Oracle Team

By Franck Pachot . The documentation says that for Reduction of duplication and Ease of database upgrade the Oracle-supplied objects such as data dictionary table definitions and PL/SQL packages are represented only in the root. Unfortunately,(…)

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

What is in a transportable tablespace dumpfile?

08.05.2017 by Oracle Team

By Franck Pachot . On 31st of May in Düsseldorf, at DOAG Datenbank, I'll talk about transportable tablespaces and pluggable databases. Both methods are transporting data physically, the difference is in the transport of the metadata,(…)

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

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

Multitenant internals: object links on fixed tables

07.08.2016 by Oracle Team

By Franck Pachot . The previous post partly answered to the original question (why an object link to V$SESSION is refreshed only every 30 seconds): recursive queries on shared=object views. Now let's see what is different(…)

Database Administration & Monitoring

Multitenant internals: how object links are parsed/executed

07.08.2016 by Oracle Team

By Franck Pachot . I had a comment on object links internals when creating a sharing=object view on GV$SESSION. Before posting about this specific case, I realized that I've never explained how a query on(…)