My Oracle Support Banner

ODA (Oracle Database Appliance): Howto Configuring and Monitoring Instance Caging (Doc ID 1474290.1)

Last updated on JUNE 11, 2023

Applies to:

Oracle Database Appliance Software - Version 2.1.0.1 and later
Oracle Database Appliance - Version All Versions and later
Information in this document applies to any platform.

Goal

This article provides a step-by-step guide for configuring Instance Caging on ODA.

You can consolidate multiple databases using Oracle Database Appliance. Oracle Database provides a method for managing CPU allocations on a multi-CPU server running multiple database instances. This method is called instance caging. Instance caging and Oracle Database Resource Manager support the desired levels of service across multiple instances. Consolidation can minimize idle resources, maximize efficiency, and lower costs.

Oracle Database Appliance templates are designed by default to run on a specific number of cores. You can use instance caging and Oracle Database Appliance to deploy multiple databases on Oracle Database Appliance using Oracle Database Appliance templates that are pre-tuned for the size of each database instance workload. You can also select database template sizes that provide additional capacity for planned growth.

Note:

Oracle strongly recommends that you use the Oracle Database Appliance templates, because they implement best practices and are configured specifically for Oracle Database Appliance.
You can use either Oracle Appliance Manager or Database Configuration Assistant (DBCA) to create databases on Oracle Database Appliance. The templates are available with both utilities.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 
 Determine Number of CPUs
 Determine "cpu_count" for All Instances
 Enabling Instance Caging for Oracle Database Appliance
 Monitor Instance Caging
 Tuning Instance Caging
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.