Oracle International Corporation

Yixiao Shen

Nicolas Michael

Kumar Rajamani

Jaebock Lee

Giridhar Ravipati

Sanket Jain

Glenn Faden

Embodiments provide a migration instruction that effectuates the migration of a pluggable database from a source database server instance to a destination database server instance. Upon receiving the migration instruction, the migrating pluggable database is opened at the destination instance. Connections are terminated at the source instance at a rate that is determined based on statistics maintained for one or more of: the migrating pluggable database, the source instance, the destination instance, a container database, etc. Furthermore, once the migration instruction is received, a certain amount of time is provided before the source instance flushes the dirty buffers for the migrating pluggable database from the buffer cache of the source instance. The delay in flushing dirty buffers from buffer cache allows the source instance to provide data blocks, of the migrating pluggable database, directly to the destination database server instance from the cache.

Migrating a pluggable database between database server instances with minimal impact to performance

A method for a live migration in a multitenant clustered database aimed at providing efficient migration of transactional online databases with no service interruption or failed requests and minimal impact on quality of service. The migration is facilitated by a client connection pool, which migrates connections from the source node to the target node using a self-adapting algorithm to control the migration rate. The algorithm calculates a base migration rate according to the relative number of connections transferred to the target node. Once base migration rate is calculated, the algorithm accelerates or throttles the base migration rate based on workload behavior and system load, attempting to minimize impact on the migrated tenant, while keeping overall migration time low.

Determining live migration speed based on workload and performance characteristics

Implementations of PDB Sandboxing in layers and mapping to different operating systems are described. In exemplary implementations, one or more pluggable databases (PDBs) are encapsulated on common container databases to form one or more PDB sandboxes. Encapsulating PDBs forms an isolation boundary layer configured to dynamically regulate security and isolation of the PDB sandboxes. Access by processes and resources to and from the PDBs inside respective PDB sandboxes through the isolation boundary layer, and access within PDB sandboxes, is regulated using dynamic access processes that dynamically vary access to resources and process disposed within and external to the PDB sandboxes.

Growing community of inventors

San Ramon, CA, United States of America

Yixiao Shen