default_storage_cache_policy

Description

default_storage_cache_policy specifies the default cache strategy for tables. The default value of the storage_cache_policy parameter at the tenant level is effective only for newly created tables.

Privilege requirements

• Query the parameter

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

• Modify the parameter

  The sys tenant and user tenants can modify this parameter.

  Notice

  If you modify this parameter in an Oracle tenant or in the sys tenant by specifying an Oracle tenant or another non-user tenant (such as the sys tenant or the meta tenant), the value of the parameter can be modified, but the feature does not take effect. This is because the feature to manually specify the cache strategy for hot data is effective only in MySQL mode.

Attributes

Considerations

• All newly created tables in the current tenant use the cache strategy specified by default_storage_cache_policy if the storage_cache_policy parameter is not explicitly specified.
• Only user tables and indexes are affected by the default_storage_cache_policy parameter. System tables are always set to AUTO.

Examples

• In a user tenant, set the default cache strategy to HOT.

  obclient> ALTER SYSTEM SET default_storage_cache_policy='HOT';
  

• In the sys tenant, set the default cache strategy to HOT for the mysqltenant tenant.

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