ericgg 发表于 2011-2-18 13:34:21

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

win32位 oracl11   4g内存
这个是和内存有关系 还是和 客户端占用缓存有关系呀    weep Incident: 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


oraunix 发表于 2011-2-19 22:43:59

应该是磁盘空间不足,看一下temp表空间。
页: [1]
查看完整版本: oracle11 的sga pga应该怎么分配 导致存储空间不足