本文介绍了一个Oracle数据库性能优化技巧：通过设置PRE_PAGE_SGA参数，在实例启动时预读整个SGA到内存中并预先构建操作系统页表条目。这可能会增加启动时间，但能减少达到全速运行所需的时间。
PRE_PAGE_SGA determines whether Oracle reads the entire SGA into memory at
instance startup. Operating system page table entries are then prebuilt for each page of
the SGA. This setting can increase the amount of time necessary for instance startup,
but it is likely to decrease the amount of time necessary for Oracle to reach its full
performance capacity after startup.
[@more@]来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-968765/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-968765/
扫一扫
2079
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
