xrmemcache Attribute

7.7.1.7.9 xrmemcache Attribute

Purpose

The xrmemcache attribute controls use of the Exadata RDMA Memory Cache (XRMEM cache) by a database. This ensures that cache space is reserved for mission-critical databases.

Syntax

ALTER IORMPLAN 
   dbplan=(( name=db_name, ... xrmemcache={on|off}  ... ) ... )

Usage Notes

By default, any database can use the XRMEM cache unless it is affected by a directive that specifies xrmemcache=off.
xrmemcache=off is invalid in a directive that contains the xrmemcachemin, xrmemcachelimit, or xrmemcachesize attributes.
On Exadata X8M and X9M systems with Oracle Exadata System Software release 23.1.0, the persistent memory data accelerator, previously known as PMEM cache, is now called XRMEM cache.

For backward compatibility, on Exadata X8M and X9M systems, you can use pmemcache instead of xrmemcache in the ALTER IORMPLAN command. However, starting with Oracle Exadata System Software release 23.1.0, output from the LIST IORMPLAN command only displays xrmemcache.

Example 7-47 Setting XRMEM Cache Use in a Database Plan

This example shows how to enable XRMEM cache use in a database plan.

CellCLI> ALTER IORMPLAN                                        -
         dbplan=((name=sales_prod, xrmemcache=on),             -
                 (name=sales_dev, xrmemcache=off),             -
                 (name=sales_test, xrmemcache=off),            -
                 (name=DEFAULT, xrmemcache=off))

Parent topic: ALTER IORMPLAN