processor_group_name - limit resources for each database and pdb

Use Resource Management best practices to guarantee and limit resources for each database and PDB.

Instance Caging - Managing Multiple Database Instances on a Single Server

Instance caging is another small but useful feature of Oracle Database 11g Release 2. Thanks to it the database resource manager is able, to limit the number of CPUs that can be used by a given instance simultaneously. This feature allows Oracle DBAs to easily manage Oracle Instance CPU consumption.

There are two typical approaches to instance caging for a server:

• Over-provisioning:
  In this approach, the sum of the CPU limits for each instance exceeds the actual number of CPUs on the system.
• Partitioning:In this approach, the sum of allocate CPUs for each instance is equal to the number of CPUs on the server

Global Cache Service Processes in a Oracle Cluster (RAC) with Multiple Databases

Creating a cluster with a single pool of storage managed by Oracle ASM provides the infrastructure to manage multiple databases whether they are single instance databases or Oracle RAC databases.

With Oracle RAC databases, you can adjust the number of instances and which nodes run instances for a given database, based on workload requirements. Features such as cluster-managed services allow you to manage multiple workloads on a single database or across multiple databases. It is important to properly manage the capacity in the cluster when adding work. The processes that manage the cluster—including processes both from Oracle Clusterware and database—must be able to obtain CPU resources in a timely fashion and must be given higher priority in the system.