Using IORM to Control Database Access to Exadata Cache Resources

5.1.3.3 Using IORM to Control Database Access to Exadata Cache Resources

You can use IORM to manage access to valuable Oracle Exadata Storage Server cache resources.

You can use the flashcache and flashlog attributes in the interdatabase IORM plan to control access to Exadata Smart Flash Cache and flash log. You can set flashcache=off to prevent the specified database from using the flash cache. Likewise, setting flashlog=off prevents the specified database from using the flash log. By default, all databases can use flash memory for caching and logging.

Likewise, on appropriately configured servers, you can use xrmemcache and xrmemlog attributes to control access to Exadata RDMA Memory (XRMEM) resources.

Note:

On Exadata X8M and X9M storage server models only, you can use pmemcache and pmemlog attributes interchangeably with xrmemcache and xrmemlog. However, you cannot have a mixture of PMEM and XRMEM attributes in the IORM plan.

These attributes allow valuable cache resources to be reserved for mission-critical databases, especially in consolidated environments.

Parent topic: About Interdatabase Resource Management