Analyze pluggable database with Panorama


Panorama now supports analysis of pluggable databases (PDB) too.

Visibility of informations in CDB and PDB

There are different informations visible wether you are selecting from DBA_xx-views or CDB_xx-views and your are connected to CDB or PDB
Role / user connectedContainer-DB (CDB / root)Pluggable database (PDB)
Kind of viewsCDB_xxDBA_xxCDB_xxDBA_xx
systemall PDBs including rootall PDBs including rootnothingyour current PDB
user (SELECT ANY DICTIONARY)all PDBs including rootroot CDBnothingyour current PDB

Comments

Popular posts from this blog

Oracle-DB: How to check for appropriate sequence caching

Common pitfalls using SQL*Net via Firewalls

Oracle-DB: Identify excessive logon/logoff operations with short-running sessions