4.6 Using Exascale Resource Profiles with Oracle Database

This topic describes how to manage Exascale resources by associating a database with a resource profile.

By default, without any resource profiles in the system, every Oracle database has unlimited access to Exascale vault I/O resources and multiple databases share vault I/O resources equally when the system is under load.

To enable more granular I/O resource management and prioritize resource utilization, you can associate each Oracle database with an Exascale resource profile, which defines a collection of resource limits and settings. Resource profiles enable consistent resource management across numerous clients by defining resource settings once and applying them to all associated databases. In most deployments, a small number of profiles define a resource hierarchy, and each database is assigned to a single profile.

To associate an Oracle database with an Exascale resource profile, you must specify the resource profile name as the value for the db_performance_profile Oracle Database instance parameter (init.ora parameter). For example:

SQL> ALTER SYSTEM SET db_performance_profile=my-resource-profile SCOPE=spfile;

When the database starts, Exascale notes the db_performance_profile setting and automatically applies the corresponding resource profile.