Oracle 参数 OBJECT_CACHE_OPTIMAL_SIZE 官方解释，作用，如何配置最优化建议
本站中文解释
OBJECT_CACHE_OPTIMAL_SIZE参数控制Oracle数据库中对象信息在内存中的缓存大小，采用K为单位，默认是128K。如果此参数中设置较大的值，能够提高检索数据对象的性能，但是也会占用更多内存，因此应该根据实际系统的需求来决定设置的参数值大小。
1、使用SQLPLUS登录，更改OBJECT_CACHE_OPTIMAL_SIZE参数的值：
ALTER SYSTEM SET OBJECT_CACHE_OPTIMAL_SIZE=256K;
2、在服务器上修改配置文件：
vi *$ORACLE_HOME/dbs/init*.ora
添加：OBJECT_CACHE_OPTIMAL_SIZE=256K
3、重新启动Oracle实例：
shutdown immediate;
startup;
4、确认参数变更：
show parameter OBJECT_CACHE_OPTIMAL_SIZE
此查询将显示 OBJECT_CACHE_OPTIMAL_SIZE 的新值 256K。
官方英文解释
OBJECT_CACHE_OPTIMAL_SIZE specifies (in bytes) the size to which the session object cache is reduced when the size of the cache exceeds the maximum size.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
10 KB to operating system-dependent maximum |
|
Basic |
No |
The object cache is a memory block on the client that allows applications to store entire objects and to navigate among them without round trips to the server. On the server, it is used to cache frequently used objects requested as a result of client requests to help in performance.
See Also:
Pro*C/C++ Programmer’s
Guide and Oracle Call Interface
Programmer’s Guide for information on precompiler use of the object cache
