Help Center/ GaussDB/ Developer Guide(Centralized_3.x)/ Configuring Running Parameters/ GUC Parameters/ Global PL/SQL Cache Parameters
Updated on 2024-05-07 GMT+08:00
View PDF
Share

Global PL/SQL Cache Parameters

enable_global_plsqlcache

Parameter description: Specifies whether to globally cache compilation products of packages, stored procedures, and functions, and cache execution products at the session level. Enabling this function can save memory usage of database nodes in high concurrency scenarios.

This parameter is a POSTMASTER parameter. Set it based on instructions provided in Table 1.

Value range: Boolean
  • on indicates that compilation products are cached globally.
  • off indicates that global cache is not performed.

Default value: off

max_execute_functions

Parameter description: Specifies the number of execution products of stored procedures and functions in a session. This parameter must be set when enable_global_plsqlcache is set to on. Otherwise, the setting is invalid.

If the number of execution products is greater than the value of max_execute_functions, only the most recently invoked execution products (the number is specified by max_execute_functions) are retained and others are cleared.

This parameter is a POSTMASTER parameter. Set it based on instructions provided in Table 1.

Value range: a value ranging from 1 to 2147483647.

Default value: 1000

Parent topic: GUC Parameters