我在ORACLE9I上设置pre_page_sga=true,结果启动后发现ORACLE所占内存并没有设置的那么大,应该是SGA没完全加载到内存中去吧,用的还是虚拟内存.在10G上设置这个参数SGA马上就全加到内存中了,我在另外的一台装9I的机器上也试过,还是无效.我的9I是9.2.0.1,版本有关系吗?
解决方案 »
- 数据库倒库怎么会出现以his结尾的表
- oralce 非空行和空行合并
- oralce 日期问题
- 如何让oracle数据库只能启动到mount状态
- exp的QUERY选项怎使用?
- Oracle 中使用insert 语句插入中文数据 提交后出现乱码.
- 在secureCRT中执行SQLPLUS显示-bash: sqlplus: command not found怎么办
- Oracle的系统表问题
- 哪裡可以下載Oracle8i的企業管理器
- oracle安装完后,有没有在线帮助一类的东西?????
- sql文件中调用存储过程问题
- 11g中,OracleDBConsoleorcl不能启动,需要查看什么目录下的什么日志文件呢?
PRE_PAGE_SGA can increase the process startup duration, because every process that starts must access every page in the SGA. The cost of this strategy is fixed; however, you might simply determine that 20,000 pages must be touched every time a process starts. This approach can be useful with some applications, but not with all applications. Overhead can be significant if your system frequently creates and destroys processes by, for example, continually logging on and logging off.The advantage that PRE_PAGE_SGA can afford depends on page size. For example, if the SGA is 80 MB in size and the page size is 4 KB, then 20,000 pages must be touched to refresh the SGA (80,000/4 = 20,000).If the system permits you to set a 4 MB page size, then only 20 pages must be touched to refresh the SGA (80,000/4,000 = 20). The page size is operating system-specific and generally cannot be changed. Some operating systems, however, have a special implementation for shared memory whereby you can change the page size. 这个参数不单会导致启动的时候变慢,而且会导致建立连接的时候变慢,9i的某些版本可能因为bug导致这个参数没有起到作用
PRE_PAGE_SGA 参数
http://tolywang.itpub.net/post/48/384644
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716