5.2.3.7 Controlling Access to XRMEM Resources
You can use IORM to manage access to Exadata RDMA Memory (XRMEM) resources.
You can use the xrmemcache
and
xrmemlog
attributes in the interdatabase plan
to control access to XRMEM cache and XRMEM log. When set in the interdatabase
plan, these attributes control access by a specific
database.
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.
The following example shows how to disable XRMEM cache and XRMEM log for the
prod_test
and prod_dev
databases. In the example, XRMEM log is also disabled for the
dw_test
database.
CellCLI> ALTER IORMPLAN -
dbplan=((name=prod, xrmemcache=on, xrmemlog=on), -
(name=dw, xrmemcache=on, xrmemlog=on), -
(name=prod_test, xrmemcache=off, xrmemlog=off), -
(name=prod_dev, xrmemcache=off, xrmemlog=off), -
(name=dw_test, xrmemcache=on, xrmemlog=off))
You can also use these attributes in conjunction with other attributes. For example:
CellCLI> ALTER IORMPLAN -
dbplan=((name=prod, share=8, xrmemcache=on, xrmemlog=on), -
(name=dw, share=6, xrmemcache=on, xrmemlog=on), -
(name=prod_test, share=2, xrmemcache=off, xrmemlog=off), -
(name=prod_dev, share=1, xrmemcache=off, xrmemlog=off), -
(name=dw_test, share=2, xrmemcache=on, xrmemlog=off), -
(name=other, share=1))
You do not need to explicitly set
xrmemcache=on
or xrmemlog=on
because they are the default settings.
Parent topic: Administering the IORM Plan