internals

12c Multitenant internals: AWR tables and views

By Franck Pachot . I received a question about multitenant. AWR tables are often raised as an example of Object Links because automatic workload repository is stored only in CDB$ROOT. However, neither the views DBA_HIST... nor the tables WRH$_... are(…)

Oracle multitenant dictionary: upgrade

By Franck Pachot . This is a second part of the previous post about metadata link. I’ve shown how a sharing=metadata function becomes a sharing=none function when it is changed in the pdb – i.e when not having(…)

Oracle multitenant dictionary: metadata links

By Franck Pachot . As in previous posts (1 and 2) I’m still playing with multitenant dictionary. You may wonder why I’m spending time to do unsupported things that we will never be able to use in(…)

Oracle multitenant dictionary: object links

By Franck Pachot . I’ve described Oracle 12c metadata and object links internals in a previous post. But before that, the first time I investigated on it, I made a wrong assumption because I was looking at AUDIT_ACTIONS(…)

How to list all Oracle system schemas

By Franck Pachot . Do you want to know which users come with the Oracle Database and which are the ones you have created? This is that not easy, especially prior to Oracle 12c. You know SYS and SYSTEM,(…)

Oracle 12c CDB – metadata & object links internals

By Franck Pachot . Warning: this is only geek stuff about internals on multitenant database dictionary, metadata, and object links. It has nothing to do with the operations that you can do on your database. Don’t try that in(…)