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 ofxrmemlog
in theALTER IORMPLAN
command. However, starting with Oracle Exadata System Software release 23.1.0, output from theLIST IORMPLAN
command only displaysxrmemlog
.
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))
Parent topic: ALTER IORMPLAN