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.