Chinaunix首页 | 论坛 | 博客
  • 博客访问: 355369
  • 博文数量: 80
  • 博客积分: 2056
  • 博客等级: 大尉
  • 技术积分: 961
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-19 12:17
文章分类

全部博文(80)

文章存档

2011年(9)

2010年(13)

2009年(41)

2008年(17)

我的朋友

分类: Oracle

2010-12-01 12:16:47

:

Note:430492.1

 

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.3
Linux x86

Symptoms

ORA-27102, Out of memory error


Cause

For 32 bit system running smp kernel, we cannot have SGA > 1.7 GB directly. This is because of
limitation of 32 bit systems of not being able to address memory > 4GB directly by a user process.
If SGA is kept higher than 1.7 GB, it will results in ORA 27102 errors.

While invoking dbca or creating starter database, by default it takes 40% of memory for SGA.
Hence the size can accidentally exceed 1.7 GB




Solution

The workaround is to create a new database, and specify the size of SGA approximate to be 1.5 to
1.7 GB.


References

 - Summary About the Large SGA & Address Space on RH Linux

Errors

 out of memory

阅读(1197) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~