7.7.1.7.10 pmemcache Attribute

Purpose

The pmemcache attribute controls use of the persistent memory (PMEM) cache by a database. This ensures that cache space is reserved for mission-critical databases.

Note:

This attribute applies to Oracle Exadata System Software releases before 23.1.0. Otherwise, see xrmemcache Attribute.

Syntax

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

Usage Notes

• By default, any database can use the PMEM cache unless it is affected by a directive that specifies pmemcache=off.

• pmemcache=off is invalid in a directive that contains the pmemcachemin, pmemcachelimit, or pmemcachesize attributes.

Example 7-48 Setting PMEM Cache Use in a Database Plan

This example shows how to enable PMEM cache use in a database plan.

CellCLI> ALTER IORMPLAN                                        -
         dbplan=((name=sales_prod, pmemcache=on),             -
                 (name=sales_dev, pmemcache=off),             -
                 (name=sales_test, pmemcache=off),            -
                 (name=DEFAULT, pmemcache=off))