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, an 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, you can associate an Oracle database with an Exascale resource profile, which defines a collection of resource limits and settings. If you associate multiple databases with an Exascale resource profile, then the databases equally share the resources specified in the resource 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=myresourceprofile SCOPE=spfile;