Oracle Multitenant : Statspack on steroids

If like me you like having the full picture of the system, then you may want to install statspack at the CDB level. Ok it’s not supported but every one has his own position on that :p Franck Pachot already wrote about that a while ago :

• http://viewer.zmags.com/publication/dd9ed62b#/dd9ed62b/36
• https://blog.dbi-services.com/awrrpt-and-spreport-in-multitenant/

One important missing piece of information (among others) when doing that is that it will not capture the different sql statement at the PDB level, for that we will need to install statspack at the PDB level also but there is another alternative : Statspack on steroids :p

Oracle to PostgreSQL migration : Watch-out for MVCC violation

When migrating from oracle database to PostgreSQL there are a lot of thing to do and check , we must consider the capability and limitation of our target environment. In this case i will focus on some MVCC Caveats when using the default Read Committed isolation level as must application out there don’t change the default any way.