首页 » ORACLE, 系统相关 » 在32位操作系统下SGA支持大内存

在32位操作系统下SGA支持大内存

32位的操作系统安装oracle 有很多限制,如果是生产库我觉的你可以毫不犹豫的用64位操作系统,2的32次方 得到了系统所认内存的大小限制为4G左右,下面是一张ORACLE在LINUX下的内存映射图

怎么在配置ORACLE时把sga突破这1.7g的限制,涉及到另一个概念PAE全名Page Address Extensions,WINDOWs 2000以后的服务器版或linux都可以实现,现在介绍一下如果在WINDOWS 2003下做到让SGA支持大于1.7G的内存

rem _db_block_lru_latches=cpu_count*2*8
alter system set “_db_block_lru_latches”=64 scope=spfile;
rem 32bit os 1.7G以上SGA必须设置USE_INDIRECT_DATA_BUFFERS为真
alter system set USE_INDIRECT_DATA_BUFFERS=true scope=spfile;
rem 去掉sga_max_size和db_cache_size参数,否则不支持32bit大容量sga
alter system reset sga_max_size scope=spfile sid=’*’;
alter system reset db_cache_size scope=spfile sid=’*’;
rem 设置该参数可以确保启动时内存不溢出
alter system set lock_sga=false scope=spfile;
rem 800MB
alter system set shared_pool_size=838860800 scope=spfile;
rem 358400*8192=2.8G db_cache_size
alter system set db_block_buffers=358400 scope=spfile;
rem 100MB
alter system set large_pool_size=104857600 scope=spfile;
rem 100MB
alter system set java_pool_size=146800640 scope=spfile;
rem 3G
alter system set pga_aggregate_target=3221225472 scope=spfile;
alter system set open_cursors=700 scope=spfile;
alter system set cursor_sharing=similar scope=spfile;
rem 启用作业调度
alter system set job_queue_processes=3 scope=spfile;
rem 启用日志挖掘
alter system set logmnr_max_persistent_sessions=3 scope=spfile;
rem 3M
alter system set log_buffer=3145728 scope=spfile;
rem 归档日志模式
alter system set log_archive_dest=’e:archivelogchs’
alter system set log_archive_start=TRUE

rem   部分为注释

–注册表HKEY_LOCAL_MACHINESOFTWAREOracleHome0AWE_WINDOW_MEMORY=274572800(_db_block_lru_latches*4096*db_block_size+5MB)
–Windows 2003启动加/PAE参数

以下是一个 Boot.ini 文件的示例,其中已添加了 PAE 开关:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS=”Windows Server 2003, Enterprise” /fastdetect /PAE

boot.ini 文件在哪找?

右击我的电脑–属性–高级–启动和故障恢复里的设置–弹出的窗口选择编辑 弹出的就是。修改完成后保存重启生效(不要乱改哟)

总之,PAE (Page Address Extensions)是 Windows 2000 和 Windows Server 2003 内存管理器的一项功能,它为请求内存的程序提供了更多物理内存。程序并不知道它正使用的内存中有些在大于 4 GB 的范围内,正如程序不知道它请求的内存实际上是在页面文件中一样。

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Daniel Enix | #1
    2011-12-21 at 07:16

    Unquestionably consider that that you said. Your favorite justification seemed to be at the internet the simplest factor to take note of. I say to you, I certainly get irked whilst other folks consider worries that they plainly don’t understand about. You controlled to hit the nail upon the highest and also defined out the whole thing without having side-effects , other folks can take a signal. Will probably be back to get more. Thanks…freecreditreport.com