Oracle教程 2023-02-26

Oracle 参数 JAVA_POOL_SIZE 官方解释，作用，如何配置最优化建议

本站中文解释

JAVA_POOL_SIZE参数的功能：

Oracle JAVA_POOL_SIZE参数用于控制Oracle中用于存储java池大小的大小。Java池用于存储存储java虚拟机和java库分配的内存。

正确设置JAVA_POOL_SIZE参数：

1、确定您的系统能够提供多少内存给Oracle；

2、确定Oracle使用多少内存来作为JAVA_POOL_SIZE；

3、将合理的JAVA_POOL_SIZE设为配置文件参数；

4、调整参数，观察性能；

5、如果效果不理想，请调整参数值；

6、最终注意不要发现内存泄露，检查是否溢出和其他错误。

官方英文解释

JAVA_POOL_SIZE specifies (in bytes) the size of the Java pool, from which the Java memory manager allocates most Java state during run-time execution. This memory includes the shared in-memory representation of Java method and class definitions, as well as the Java objects that are migrated to the Java session space at end-of-call.

Property	Description
Parameter type	Big integer
Syntax	`JAVA_POOL_SIZE =` `integer` `[K \| M \| G]`
Default value	If `SGA_TARGET` is set: If the parameter is not specified, then the default is `0` (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool. If `SGA_TARGET` is not set: `24` MB, rounded up to the nearest granule size
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	No
Range of values	Minimum: `0` (values greater than zero are rounded up to the nearest granule size) Maximum: operating system-dependent
Basic	No

本站中文解释

官方英文解释

相关推荐