Infrastructure at your Service

multitenant Archives - Page 6 of 6 - Blog dbi services

Franck Pachot

Franck Pachot: Oracle multitenant dictionary: upgrade

By | Database management, Oracle | No Comments

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 the same DDL, not having a different signature. Here is another experimentation doing the opposite: change the function in root and see what happens in the pdb. Again playing with internals in order to understand the ‘upgrade by unplug-plug’ feature available…

 
Read More
Franck Pachot

Franck Pachot: Oracle multitenant dictionary: metadata links

By | Database management, Oracle | 2 Comments

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 real life. Of course, playing with internals is fun But it’s not only that. We will implement CDB databases (multi-tenant, and single-tenant as I think non-CDB will be deprecated in future versions). We will operate pluggable databases (clone, upgrade, downgrade,…), encounter issues,…

 
Read More
Franck Pachot

Franck Pachot: Oracle multitenant dictionary: object links

By | Database management, Oracle | 3 Comments

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 which is not correctly implemented. That investigation came from a question on dba-village. And recently Ivica Arsov (@IvicaArsov) has made an interesting comment about AUDIT_ACTIONS object link table, so I’ll explain here what is special with it. AUDIT_ACTIONS Here is how…

 
Read More
Franck Pachot

Franck Pachot: Oracle 12c CDB – metadata & object links internals

By | Database management, Oracle | 21 Comments

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 production or you can corrupt the whole dictionary. In 12 multitenant database (aka CDB) we know that each pluggable database is isolated in order to act as a standalone database. But they share some common resources because that’s the main…

 
Read More