suspend_storage_cache_task

Description

The suspend_storage_cache_task parameter specifies whether to suspend background cache tasks.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can query 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

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

Attributes

Examples

• User tenant

  1. Suspend cache tasks in the current user tenant.

     obclient> ALTER SYSTEM SET suspend_storage_cache_task = True;
     

  2. Resume cache tasks in the current user tenant.

     obclient> ALTER SYSTEM SET suspend_storage_cache_task = False;
     

• System tenant

  1. Suspend cache tasks in the mysqltenant tenant.

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

  2. Resume cache tasks in the mysqltenant tenant.

     obclient> ALTER SYSTEM SET suspend_storage_cache_task = False TENANT = mysqltenant;