Infrastructure at your Service

Tag

CDB Archives - Page 12 of 12 - Blog dbi services

Oracle Team

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
Oracle Team

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
Oracle Team

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
Oracle Team

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