Multitenant database

Hot Clone of a Remote PDB in a Dataguard Environment 19c

Introduction In Oracle Database 19c, if you have a Dataguard Configuration of a multitenant database, and you want to clone a pluggable database from a remote server to your primary, then you have to mind that the dataguard mechanism is(…)

Migrating Non-CDB to Multitenant

By Mouhamadou Diaw Dealing these last days to database migration with a customer, I write this blog to describe the main tasks The context is to migrate databases to a new infrastructure. Below the configuration(…)

Multitenant vs. schema based consolidation

By Franck Pachot . If you want to install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions: have one database and multiple schema have multiple databases have(…)

12c: shutdown abort a PDB?

By Franck Pachot . Can we shutdown abort a PDB? Let’s try: SQL> show con_id CON_ID ------------------------------ 3SQL> shutdown abort; Pluggable Database closed. But is it really a shutdown abort? The shutdown abort we know in non-CDB – or(…)

Oracle multitenant dictionary: rowcache

By Franck Pachot . I’ve not finished with my investigation on 12c multitenant dictionary. Here, I’m checking how metadata links are managed by the dictionary cache (aka rowcache). As I did previously, I’ll create a metadata link function(…)

Stay with non-CDB or go to CDB?

By Franck Pachot . This is a question that starts to be raised quite frequently. Oracle released the multitenant architecture 1.5 year ago. And now says that the previous architecture – known as non-CDB – is deprecated. What does(…)

Oracle 12c: comparing TTS with noncdb_to_pdb

By Franck Pachot . How to migrate from non-CDB to CDB? Of course all known migration methods works. But there is also another solution: upgrade to 12c if necessary and then convert the non-CDB to a PDB. This is(…)

When Oracle resets session statistics

By Franck Pachot . During our Oracle 12c New Features workshop I had a very good question about whether the session statistics are reset or not when doing ALTER SESSION SET CONTAINER. My initial thought was that they(…)

12.1.0.2 CDB views are now using CONTAINERS()

By Franck Pachot . I’ve blogged about multitenant internals at the time when 12.1.0.1 was just released. Something has changed in 12.1.0.2 and blogging about it was in my todo list for a long time. Now the occasion(…)

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