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 reduce the memory usage of database nodes in high concurrency scenarios. This parameter must be disabled for the multi-tenant database feature (enable_mtd).
Parameter type: Boolean.
Unit: None
- on: Global cache is performed on compilation products.
- off: Global cache is not performed.
Default value: on
Setting method: This is a POSTMASTER parameter. Set it based on instructions provided in Table 1.
Setting suggestion: If there are a large number of stored procedures and package objects and the concurrency is high, you are advised to enable this function to save memory.
Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing.
max_execute_functions
Parameter description: Specifies the maximum number of execution products of stored procedures and functions in a session. When the number of execution products is greater than the value of max_execute_functions, the system clears the execution products and retains the latest max_execute_functions execution products. This parameter is valid only when enable_global_plsqlcache is set to on.
Parameter type: Integer
Unit: None
Value range: 1 to 2147483647
Default value: 1000
Setting method: This is a POSTMASTER parameter. Set it based on instructions provided in Table 1.
Setting suggestion: You are advised to set this parameter to a proper value based on the system memory size. A larger memory size indicates that you can set a larger value.
Risks and impacts of improper settings: If the value is too small, the performance may be affected.
max_compile_packages
Parameter description: Specifies the maximum number of package compilation results stored in the server.
Parameter type: Integer
Unit: None
Value range: 0 to 2147483647. The value 0 indicates that this function is disabled and the maximum number of package compilation products is not controlled. The value of this parameter can be adjusted based on different specifications. The recommended value can be obtained by rounding down the value of (max_process_memory x 2%)/4.4, in MB.
The value 4.4 MB is the average value obtained based on the simulation statistics in the lab. You need to observe the value in the actual scenario. If the value does not comply with the actual scenario, you need to adjust the value to adjust the memory usage of the stored procedure.
Default value:
Default values for different specifications are calculated by rounding down (max_process_memory x 2%)/4.4, in MB.
Setting method: This is a SIGHUP parameter. Set it based on instructions provided in Table 1.
Setting suggestion: Storing too many package compilation results may occupy a large amount of memory. Setting this parameter to a proper value helps reduce memory usage and improve system performance.
Risks and impacts of improper settings: If the value is too small, the global cache will be frequently eliminated, which may affect the performance.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot