Oracle Multitenant

Multitenant internals: object links on fixed tables

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

Multitenant internals: how object links are parsed/executed

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

Oracle Multitenant feature name

By Franck Pachot . We all know what is the multitenant option: a container database (CDB) with multiple user pluggable databases (PDB). This requires Enterprise Edition plus option. But you can use the same architecture without the option and even(…)