Infrastructure at your Service

Tag

CDB Archives - Page 11 of 11 - Blog dbi services

Franck Pachot

Oracle multitenant dictionary: metadata links

By | Database management, Oracle | 2 Comments

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

Read More
Franck Pachot

Oracle multitenant dictionary: object links

By | Database management, Oracle | 3 Comments

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 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….

Read More
Franck Pachot

Oracle 12c: comparing TTS with noncdb_to_pdb

By | Database management, Oracle | No Comments

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 done with the noncdb_to_pdb.sql which converts a non-CDB dictionary to a PDB one, with metadata and object links. But do you get a clean PDB after that ? I tested it and compared the result with…

Read More
Franck Pachot

My planning for DOAG 2014

By | Database management, Oracle | No Comments

By Franck Pachot . I’m quickly checking the planning for DOAG these 3 days and here is the list of sessions I would like to attend. There are still a lot of interesting ones even if my choice is limited by the language (I would like to understand German but I’m limited so sessions in English). And I’ve still some concurrency issues to solve because I cannot be at two places at the same time….

Read More
Franck Pachot

12.1.0.2 CDB views are now using CONTAINERS()

By | Database management, Oracle | 2 Comments

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 to do it has been triggered by a question on Oracle Forums about CDB_DATA_FILES not showing PDB$SEED datafiles because there is an important change we must be aware of. In the previous blog, I have described how…

Read More
Franck Pachot

OOW14 Day 4 – Internals of the 12c Multitenant Architecture by Vit Spinka

By | Database management, Oracle | No Comments

By Franck Pachot . This is the session I preferred at Oracle Open World. Well, I’m writing that before going to @ludodba one and I’m sure I’ll have then two preferred sessions… So Vit Spinka has presented the internals of the new multitenant architecture. It’s always good to play with some internals things. Not only for the geeky fun of it but also because it helps understand how it work and address issues later. I had…

Read More
Franck Pachot

Resize your Oracle datafiles down to the minimum without ORA-03297

By | Database management, Oracle | 44 Comments

By Franck Pachot . Your datafiles have grown in the past but now you want to reclaim as much space as possible, because you are short on filesystem space, or you want to move some files without moving empty blocks, or your backup size is too large. ALTER DATABASE DATAFILE … RESIZE can reclaim the space at the end of the datafile, down to the latest allocated extent. But if you try to get lower,…

Read More
Franck Pachot

PDB media failure may cause the whole CDB to crash

By | Database management, Oracle | 3 Comments

By Franck Pachot . Do you remember last year, when 12c arrived with multitenant, David Hueber warned us about the fact that a single PDB can, under certain conditions, generate a complete system downtime? We are beta testers and opened a SR for that. Now one year later the first patchset is out and obviously I checked if the issue was fixed. It’s a patchset afterall, which is expected to fix issues before than bringing…

Read More
Franck Pachot

Beyond In-Memory, what’s new in 12.1.0.2 ?

By | Database management, Oracle | No Comments

By Franck Pachot . It’s just a patchset. The delivery that is there to stabilize a release with all the bug fixes. But it comes with a lot of new features as well. And not only the one that has been advertised as the future of the database. It’s a huge release. Let’s have a look at what’s new. First, it seems that it will be the only patchest for 12.1 Then, there is that…

Read More
Franck Pachot

Oracle 12c CDB – metadata & object links internals

By | Database management, Oracle | 24 Comments

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

Read More