Tuesday, September 22, 2015

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.

For databases that require dedicated resources for isolation, consider using the PROCESSOR_GROUP_NAME parameter to bind the instance to dedicated CPUs or NUMA nodes. PROCESSOR_GROUP_NAME is a database parameter which was introduced with Oracle 12c and is now available with 11.2.0.4 as well.




REFERENCES

  • MOS:1362445.1 - Configuring and Monitoring Instance Caging 
  • MOS:1585184.1 - Using PROCESSOR_GROUP_NAME to bind a database instance to CPUs or NUMA nodes on Linux 
  • MOS:1928328.1 - Using PROCESSOR_GROUP_NAME to bind a database instance to CPUs or NUMA nodes on Solaris