Note
This parameter is available starting with V1.4.
Description
virtual_table_location_cache_expire_time specifies the cache expiration time of the location information of a virtual table.
Privilege requirements
Query the parameter
You can execute the
SHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to obtain the value of this parameter in thesystenant and all user tenants.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Type | Time |
| Default value | 8s |
| Value range | [1s, +∞) |
| 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 cache expiration time of the location information of a virtual table to 8s.
obclient> ALTER SYSTEM SET virtual_table_location_cache_expire_time ='8s';