default_storage_cache_policy

Description

default_storage_cache_policy specifies the default cache policy. It is the default value of the storage_cache_policy parameter at the tenant level. This parameter takes effect only on new tables.

Privilege requirements

• Query the parameter

  Both the sys tenant and all user tenants can query this parameter using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.

• Modify the parameter

  Both the sys tenant and user tenants can modify this parameter.

  Notice

  Due to a limitation, manually specifying the hot data cache policy only takes effect in MySQL-compatible tenants. If you modify this parameter in an Oracle-compatible tenant, or if the sys tenant specifies an Oracle-compatible tenant or another non-user tenant (such as the sys tenant or Meta tenant) to modify this parameter, the modification will be successful but the feature will not take effect.

Attributes

Considerations

• By default, all new tables in the current tenant use the cache strategy specified by default_storage_cache_policy unless the cache strategy is explicitly specified by the storage_cache_policy parameter.
• Only user tables and indexes are affected by the default_storage_cache_policy parameter. System tables are not affected and always use the AUTO setting.

Examples

• Set the default cache strategy for the current tenant to HOT in a user tenant.

  obclient> ALTER SYSTEM SET default_storage_cache_policy='HOT';
  

• Set the default cache strategy for the mysqltenant tenant to HOT in the sys tenant.

  obclient> ALTER SYSTEM SET default_storage_cache_policy='HOT' TENANT = mysqltenant;