Abstract: A computer program product, system, and computer implemented method for scalable specification and self-governance for autonomous databases, cluster databases, and multi-tenant databases in cloud and on-prem environments. The approach disclosed herein enables management of a consolidated databases using a template-based process that allows for the consolidated databases (CDBs) and pluggable databases (PBDs) to be reconfigured automatically. In some embodiments, the approach instantiates one or more monitoring modules and one or more CDB/PDB configuration managers. These elements can detect relevant changes in the conditions in which CDB instances and open PDBs operate and adjust the configurations thereof in response.

Abstract: Herein are resource-constrained techniques that plan ahead for resiliently moving pluggable databases between container databases after a failure in a high-availability database cluster. In an embodiment, a computer identifies many alternative placements that respectively assign each pluggable database to a respective container database. For each alternative placement, a respective resilience score is calculated for each pluggable database that is based on the container database of the pluggable database. Based on the resilience scores of the pluggable databases for the alternative placements, a particular placement is selected as an optimal placement that would maximize utilization of computer resources, minimize database latencies, maximize system throughput, and maximize the ability of the database cluster to avoid a service outage.

Abstract: Techniques are described herein for isolating a network stack in a multitenant container DBMS. A first and second pluggable database are established within a container database. A first network stack is assigned to the first pluggable database and a second network stack is assigned to the second pluggable database. A request is received to connect to the first pluggable database and a connection is established to the first pluggable database using the first network stack. A request is received to connect to the second pluggable database and a connection is established to the second pluggable database using the second network stack.

Abstract: Techniques are provided herein for assigning pluggable database connections to thread groups. The techniques involve associating pluggable databases with thread groups. Each thread group is associated with a process running on a NUMA node. When a request for a connection for a pluggable database is received, the system determines which process on which NUMA node to spawn a thread for connecting to the pluggable database.

Abstract: Techniques are described herein for intelligent pooling and management of isolated hierarchical runtimes in a multi-tenant environment. In an embodiment, an allocation of operating system resources of a container database management system (CDBMS) is allocated to each generic nest of a pool of generic nests. The allocation includes a quota of one or more processors and a quota of memory. A configuration profile for a PDB in the CDBMS is then determined. Based on the configuration profile determined for the PDB, a matching generic nest from the pool of generic nests is determined. A matching generic nest is assigned to the PDB. The matching generic nest is then configured for the PDB.

Abstract: Many computer applications comprise multiple threads of executions. Some client application requests are fulfilled by multiple cooperating processes. Techniques are disclosed for creating and managing memory namespaces that may be shared among a group of cooperating processes in which the memory namespaces are not accessible to processes outside of the group. The processes sharing the memory each have a handle that references the namespace. A process having the handle may invite another process to share the memory by providing the handle. A process sharing the private memory may change the private memory or the processes sharing the private memory according to a set of access rights assigned to the process. The private shared memory may be further protected from non-sharing processes by tagging memory segments allocated to the shared memory with protection key and/or an encryption key used to encrypt/decrypt data stored in the memory segments.

Abstract: Many computer applications comprise multiple threads of executions. Some client application requests are fulfilled by multiple cooperating processes. Techniques are disclosed for creating and managing memory namespaces that may be shared among a group of cooperating processes in which the memory namespaces are not accessible to processes outside of the group. The processes sharing the memory each have a handle that references the namespace. A process having the handle may invite another process to share the memory by providing the handle. A process sharing the private memory may change the private memory or the processes sharing the private memory according to a set of access rights assigned to the process. The private shared memory may be further protected from non-sharing processes by tagging memory segments allocated to the shared memory with protection key and/or an encryption key used to encrypt/decrypt data stored in the memory segments.

Abstract: Techniques are described herein for isolating runtime environments in a multitenant container DBMS. A CDB may contain a database dictionary that defines a plurality of pluggable databases and a respective database nest for each pluggable database. Each respective database nest of said each pluggable database is associated with different operating system privileges. When database sessions are established on a container DBMS, each database session is given access to a pluggable database by attaching the respective database nest of the pluggable database to each database session.

Abstract: Techniques are described herein for isolating runtime environments in a multitenant container DBMS. A CDB may contain a database dictionary that defines a plurality of pluggable databases and a respective database nest for each pluggable database. Each respective database nest of said each pluggable database is associated with different operating system privileges. When database sessions are established on a container DBMS, each database session is given access to a pluggable database by attaching the respective database nest of the pluggable database to each database session.

Abstract: Techniques are described herein for intelligent pooling and management of isolated hierarchical runtimes in a multi-tenant environment. In an embodiment, an allocation of operating system resources of a container database management system (CDBMS) is allocated to each generic nest of a pool of generic nests. The allocation includes a quota of one or more processors and a quota of memory. A configuration profile for a PDB in the CDBMS is then determined. Based on the configuration profile determined for the PDB, a matching generic nest from the pool of generic nests is determined. A matching generic nest is assigned to the PDB. The matching generic nest is then configured for the PDB.

Abstract: Techniques are described herein for isolating a network stack in a multitenant container DBMS. A first and second pluggable database are established within a container database. A first network stack is assigned to the first pluggable database and a second network stack is assigned to the second pluggable database. A request is received to connect to the first pluggable database and a connection is established to the first pluggable database using the first network stack. A request is received to connect to the second pluggable database and a connection is established to the second pluggable database using the second network stack.

Abstract: Many computer applications comprise multiple threads of executions. Some client application requests are fulfilled by multiple cooperating processes. Techniques are disclosed for creating and managing memory namespaces that may be shared among a group of cooperating processes in which the memory namespaces are not accessible to processes outside of the group. The processes sharing the memory each have a handle that references the namespace. A process having the handle may invite another process to share the memory by providing the handle. A process sharing the private memory may change the private memory or the processes sharing the private memory according to a set of access rights assigned to the process. The private shared memory may be further protected from non-sharing processes by tagging memory segments allocated to the shared memory with protection key and/or an encryption key used to encrypt/decrypt data stored in the memory segments.

Abstract: Techniques are provided herein for assigning pluggable database connections to thread groups. The techniques involve associating pluggable databases with thread groups. Each thread group is associated with a process running on a NUMA node. When a request for a connection for a pluggable database is received, the system determines which process on which NUMA node to spawn a thread for connecting to the pluggable database.