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

Popular posts from this blog

Welcome to Oracle CertView - for Oracle CPs to track their exam attendance & certificates

-
Image
Oracle CertView This exciting new tool gives Oracle Certification candidates the ability to carry out some basic functions related to their certifications on their own, reducing wait times for information and verifications. Using this interface, you will be able to:  Review your demographic information Review your certification history Download your Oracle Certification logos Review your exam history Track your success kit status Send certification verification to a 3rd party
Read more

Connecting CMAN - Traffic Director Mode to an Oracle Database

-
Image
Oracle Connection Manager (CMAN) serves as a proxy for database connections within Oracle deployments. It facilitates the transmission of client requests to the Oracle Database and seamlessly transmits the database responses back to the client, whether it be an application, middle-tier, or other components. CMAN operates as a versatile networking solution, providing features such as TLS security, protocol switching/routing, and session multiplexing to enhance the accessibility of both local and remote Oracle databases. Traffic Director Mode (TDM) is an intelligent layer introduced in Oracle Client 18c and beyond, designed to enhance CMAN. TDM introduces additional dimensions to the system, including transparent High Availability (HA) with outage support , advanced security features for cloud environments (protection against DoS and fuzzing attacks, tenant isolation, etc.), and capabilities for optimizing performance. In summary, CMAN-TDM allows any client application to establish a ...
Read more

OracleRemExecService available Windows only

-
OracleRemExecService is a service which is only used temporarily by the OUI It gets removed when OUI is finished with it, therefore, it will have a value of 'DISABLED' until a reboot - then it will simply be gone, ignore and leave this service untouched. The Oracle Windows service "OracleRemExecService" to execute various commands from Oracle applications like DBCA and GUI. The service itself relies on a named pipe to receive the commands.
Read more