Overview
location_cache_refresh_sql_timeout specifies the timeout period for refreshing the location_cache by using SQL statements.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Only the
systenant can modify this parameter; user tenants cannot modify it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Time |
| Default Value | 1s |
| Value range | [1ms,+∞) |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Configuration example
Specifies to refresh the location_cache by using an SQL statement with a timeout period of 1 second.
obclient> ALTER SYSTEM SET location_cache_refresh_sql_timeout = '1s';