7.7.1.7.12 xrmemlog Attribute

Purpose

The xrmemlog attribute controls use of the XRMEM log by a database. This ensures that commit acceleration is reserved for mission-critical databases.

Syntax

 ALTER IORMPLAN 
   dbplan=(( name=db_name, ... xrmemlog={on|off}  ... ) ... )

Usage Notes

• By default, any database can use XRMEM log unless it is affected by a directive that specifies xrmemlog=off.

• On Exadata X8M and X9M systems with Oracle Exadata System Software release 23.1.0, the persistent memory commit accelerator, previously known as PMEM log, is now called XRMEM log.

  For backward compatibility, on Exadata X8M and X9M systems, you can use pmemlog instead of xrmemlog in the ALTER IORMPLAN command. However, starting with Oracle Exadata System Software release 23.1.0, output from the LIST IORMPLAN command only displays xrmemlog.

Example 7-50 Setting XRMEM Log Use in a Database Plan

This example shows how to control XRMEM Log use in a database plan.

CellCLI> ALTER IORMPLAN                                                                      -
         dbplan=((name=oltp, level=1, allocation=80, xrmemcache=on, xrmemlog=on),              -
                 (name=dss, level=1, allocation=20, limit=50, xrmemcache=off, xrmemlog=off),   -
                 (name=OTHER, level=2, allocation=100),                                      -
                 (name=DEFAULT, xrmemcache=off, xrmemlog=off))