Proactive performance supervision of multitenant cloud db using hierarchical triage and comparative approach maintaining the data privacy and isolation

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. The alert contains a particular metric of the level two performance metrics, and the particular metric characterizes the performance of the second PDB.