Purpose

The xrmemcachelimit attribute defines a soft limit for space usage in the Exadata RDMA Memory Cache (XRMEM cache). If the cache is not full, the limit can be exceeded.

Syntax

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

Usage Notes

• You specify the value for xrmemcachelimit 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 xrmemcachelimit must be at least 4 MB.

• The xrmemcachelimit and xrmemcachesize attributes cannot be specified in the same directive.

• The value for xrmemcachelimit cannot be smaller than xrmemcachemin, if it is specified.

• 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 pmemcachelimit instead of xrmemcachelimit in the ALTER IORMPLAN command. However, starting with Oracle Exadata System Software release 23.1.0, output from the LIST IORMPLAN command only displays xrmemcachelimit.