Abstract: Herein are hierarchical and non-intrusive techniques to detect and diagnose incidental contention between database tenants. In an embodiment, a computer hosts a database server that operates a container database. The database server monitors level one performance metrics that characterize the performance of at least a first pluggable database (PDB) in the container database. The database server detects, in the level one performance metrics, a performance degradation of the first PDB. Responsively, the database server dynamically configures collection of level two performance metrics that characterize the performance of at least the first PDB and a second PDB in the container database. The database server detects, in the level two performance metrics, that the performance degradation is caused by the second PDB. The database server generates an alert that identifies the second PDB.

Abstract: Herein are hierarchical and non-intrusive techniques to detect and diagnose incidental contention between database tenants. In an embodiment, a computer hosts a database server that operates a container database. The database server monitors level one performance metrics that characterize the performance of at least a first pluggable database (PDB) in the container database. The database server detects, in the level one performance metrics, a performance degradation of the first PDB. Responsively, the database server dynamically configures collection of level two performance metrics that characterize the performance of at least the first PDB and a second PDB in the container database. The database server detects, in the level two performance metrics, that the performance degradation is caused by the second PDB. The database server generates an alert that identifies the second PDB.