Persistent Columnar Cache

Starting with Oracle Exadata System Software release 21.2.0, the columnarCachePersMode attribute controls the persistent columnar cache feature. The valid attribute setting are:

• on - Enables the persistent columnar cache feature.

• off - Disables the persistent columnar cache feature.

• auto - Oracle Exadata System Software decides whether to enable or disable the persistent columnar cache feature. If the columnarCachePersMode attribute is not set, then the auto setting is implied.

  Starting with Oracle Exadata System Software release 21.2.11, the auto setting enables the persistent columnar cache feature (equivalent to columnarCachePersMode=on). Previously, the auto setting disabled the persistent columnar cache feature (equivalent to columnarCachePersMode=off).

After you alter the columnarCachePersMode attribute, you must restart the cell server to implement the change.

Persistent Storage Index

Starting with Oracle Exadata System Software release 21.2.0, the storageIndexPersMode attribute controls the persistent storage index feature. The valid attribute setting are:

• on - Enables the persistent storage index feature.

• off - Disables the persistent storage index feature.

• auto - Oracle Exadata System Software decides whether to enable or disable the persistent storage index feature. If the storageIndexPersMode attribute is not set, then the auto setting is implied.

  Starting with Oracle Exadata System Software release 21.2.11, the auto setting enables the persistent storage index feature (equivalent to storageIndexPersMode=on). Previously, the auto setting disabled the persistent storage index feature (equivalent to storageIndexPersMode=off).

After you alter the storageIndexPersMode attribute, you must restart the cell server to implement the change.