enable_manual_storage_cache_policy|V4.3.5|OceanBase Database| docs|Distributed Database

enable_manual_storage_cache_policy

Last Updated：2026-04-09 02:53:56 Updated

This parameter is introduced in BP2 of V4.3.5.

Description

enable_manual_storage_cache_policy specifies whether to enable the hot data cache strategy manually specified by users.

This parameter applies only to Shared-Storage (SS) mode in OceanBase Database.

Query the parameter

The sys tenant and all user tenants can execute the SHOW PARAMETERS statement or query the parameter in the GV$OB_PARAMETERS view.
Modify the parameter

The sys tenant and user tenants can modify the parameter.

Notice

The hot data cache strategy specified by users takes effect only in user tenants in MySQL mode. If you modify the parameter in an Oracle tenant or the sys tenant for a user tenant or a non-user tenant such as the sys tenant or Meta tenant, the modification succeeds but the feature does not take effect.

Attribute	Description
Parameter type	Bool
Default value	True
Value range	`True`: enables the hot data cache strategy specified by all users and uses the value of the `storage_cache_policy` parameter specified in tables, partitions, or indexes. `False`: disables the hot data cache strategy specified by all users and uses the value of the `storage_cache_policy` parameter specified in tables, partitions, or indexes. If no value is specified for tables, partitions, or indexes, the value specified for this parameter is used as the hot data cache strategy for all tables, partitions, and indexes.
Modifiability	Yes. You can modify the parameter by using the `ALTER SYSTEM SET` statement.
Effective only after OBServer restart	No, the setting takes effect immediately.

Enable the hot data cache strategy in a user tenant.

obclient> ALTER SYSTEM SET enable_manual_storage_cache_policy= True;

Enable the hot data cache strategy for the mysqltenant tenant in the sys tenant.

obclient> ALTER SYSTEM SET enable_manual_storage_cache_policy= True TENANT = mysqltenant;