xrmemcachemin Attribute

Purpose

The xrmemcachemin attribute specifies a minimum guaranteed space allocation in the Exadata RDMA Memory Cache (XRMEM cache).

Syntax

 ALTER IORMPLAN 
   dbplan=(( name=db_name, ... xrmemcachemin=number ... ) ... )

Usage Notes

You specify the value for xrmemcachemin in bytes. You can also use the suffixes M (megabytes), G (gigabytes), or T (terabytes) to specify larger values. For example, 300M, 150G, or 1T.
The value for xrmemcachemin must be at least 4 MB.
In any plan, the sum of all xrmemcachemin values cannot exceed the size of the XRMEM cache.
If xrmemcachelimit is specified, then the value for xrmemcachemin cannot exceed xrmemcachelimit.
If xrmemcachesize is specified, then the value for xrmemcachemin cannot exceed xrmemcachesize.
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 pmemcachemin instead of xrmemcachemin in the ALTER IORMPLAN command. However, starting with Oracle Exadata System Software release 23.1.0, output from the LIST IORMPLAN command only displays xrmemcachemin.