user_block_cache_priority

2026-02-03 08:48:38  Updated

Note

This parameter is available starting with V1.4.

Description

user_block_cache_priority specifies the priority of data block cache in the cache system.

Privilege requirements

  • Query the parameter

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

  • Modify the parameter

    Only the sys tenant can modify the parameter. User tenants cannot modify the parameter.

Attributes

Attribute Description
Type Int
Default value 1
Value range [1, +∞)
Modifiable Yes. You can use the ALTER SYSTEM SET statement to modify the parameter.
Effective upon OBServer node restart No. The setting takes effect immediately.

Examples

Set the priority of data block cache in the cache system to 1.

obclient> ALTER SYSTEM SET user_block_cache_priority =1;

References

Memory management within a tenant

Contact Us