-
Oracle参数解析(shared_memory_address&hi_shared_memory_address)
shared_memory_address
-
-
Attachments
-
Changes
-
View Source
-
View
前面介绍了Oracle的基本参数,从这节开始讲其他的参数,参数从v$parameter中提取
基本参数请看如下链接:
[http://www.zhaibibei.cn/oralce/oracle-parameter/](http://www.zhaibibei.cn/oralce/oracle-parameter/)
如无特殊说明数据库版本为11.2
-------
**SHARED_MEMORY_ADDRESS**
[image:191 size:orig]
--------
**HI_SHARED_MEMORY_ADDRESS**
[image:192 size:orig]
SHARED_MEMORY_ADDRESS 和 HI_SHARED_MEMORY_ADDRESS参数指定SGA的起始地址
多数OS中会在linktime时指定SGA开始地址,这时该参数会被忽略
1. 参数类型:整型
2. 默认值:见0
3. 是否可修改:修改需重启数据库
-----
**其他**
32位系统中SHARED_MEMORY_ADDRESS指定整个地址
64位系统中 SHARED_MEMORY_ADDRESS指定 low-order 32 bits of a 64-bit address
HI_SHARED_MEMORY_ADDRESS 指定high-order 32 bits of a 64-bit address
如果两者都是0或者未设置,在起始地址由操作系统指定
---------
**实际截图:**
[image:193 size:orig]
-----
参考连接
[https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams097.htm](https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams097.htm)
[https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams233.htm](https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams233.htm)
[http://www.dba-oracle.com/t_hi_shared_memory_address.htm](http://www.dba-oracle.com/t_hi_shared_memory_address.htm)
----------
下期参数
**use_large_pages**