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 :

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

Continue reading