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 thexrmemcachemin
,xrmemcachelimit
, orxrmemcachesize
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 ofxrmemcache
in theALTER IORMPLAN
command. However, starting with Oracle Exadata System Software release 23.1.0, output from theLIST IORMPLAN
command only displaysxrmemcache
.
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