Overview
shared_gc_generator_thread_score specifies the number of threads that can be used to generate shared data GC tasks simultaneously. The default value is 0, which means it is not explicitly specified. In this case, the thread score of the priority thread is used by default, and the number of threads for generating shared data GC tasks is 2 by default.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0: no explicit thread score is specified. The default thread score, which is 2, is used for tasks generated by the garbage collector for shared data. |
| Value range | [0, 100] |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
This parameter is used to dynamically adjust the number of threads for shared data GC tasks. With this configuration, the system can flexibly adjust the thread count for shared data GC tasks based on specific business requirements.
Configuration example
In the user tenant, set the number of threads for generating shared data GC tasks to 8.
obclient> ALTER SYSTEM SET shared_gc_generator_thread_score = 8;
References
To configure the number of threads available to a tenant for performing shared data GC tasks in shared storage mode, see shared_gc_executor_thread_score.