US 12,282,410 B2
Proactive performance supervision of multitenant cloud DB using hierarchical triage and comparative approach maintaining the data privacy and isolation
Amit Kendrekar, Aurangabad (IN); Harikishan Sivaramakrishnan, Karnataka (IN); and Nagarajan Muthukrishnan, San Ramon, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Sep. 21, 2023, as Appl. No. 18/471,521.
Prior Publication US 2025/0103460 A1, Mar. 27, 2025
Int. Cl. G06F 15/173 (2006.01); G06F 11/34 (2006.01); G06F 16/28 (2019.01)
CPC G06F 11/3495 (2013.01) [G06F 16/284 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
monitoring, by a database server that operates a container database, a first plurality of performance metrics that characterize the performance of at least a first pluggable database in the container database;
detecting, by the database server, in the first plurality of performance metrics that characterize the performance of at least the first pluggable database, a performance degradation of the first pluggable database;
dynamically configuring, by the database server in response to said detecting the performance degradation of the first pluggable database, collection of a second plurality of performance metrics that characterize the performance of at least the first pluggable database and a second pluggable database in the container database;
detecting, by the database server, in the second plurality of performance metrics that characterize the performance of at least the first pluggable database and the second pluggable database, that the performance degradation is caused by the second pluggable database in the container database; and
generating, by the database server, an alert that identifies the second pluggable database, wherein:
the alert contains a particular metric of the second plurality of performance metrics, and
the particular metric characterizes the performance of the second pluggable database.