oracle11 的sga pga应该怎么分配 导致存储空间不足

win32位 oracl11   4g内存
这个是和内存有关系 还是和 客户端占用缓存有关系呀    weep Incident[256341]: completed
Thu Feb 17 22:10:07 2011
Restarting dead background process DIA0
Thu Feb 17 22:10:07 2011
DIA0 started with pid=206, OS id=1628
Thu Feb 17 22:10:53 2011
Process startup failed, error stack:
Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_psp0_2324.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Thu Feb 17 22:10:53 2011
Process m000 died, see its trace file
Thu Feb 17 22:20:54 2011
Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_w000_1932.trc  (incident=256145):
ORA-04030: out of process memory when trying to allocate 1049100 bytes (KSFQ heap,KSFQ Buffers)
Thu Feb 17 22:20:54 2011
Process startup failed, error stack:
Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_psp0_2324.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr


标签: 暂无标签
ericgg

写了  篇文章,拥有财富 ,被  人关注

转播转播 分享分享 分享淘帖
回复

使用道具

P6 | 发表于 2011-2-19 22:43:59
应该是磁盘空间不足,看一下temp表空间。
回复

使用道具

您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈