服务器操作系统是Windows 2008 企业版(32位)
cup是双核4路,内存为16G。
数据库是oracle11g标准版。
sga信息如下:
NAME TYPE VALUE
------------------------------------ ------- ----------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size unknown 1468006400
sga_target unknown 0Total System Global Area 1464717312 bytes
Fixed Size 1349824 bytes
Variable Size 511706944 bytes
Database Buffers 947912704 bytes
Redo Buffers 3747840 bytesmemory_max_target 为2G
memory_target 为2047M
最大上限pga为220M
最大可分配pga为200M具体出现的问题症状描述如下:
问题1.ORA-04030 out of process memory when trying to allocate 1049100 bytes (kxs-heap-w,kllcqgf:kllsltba)
问题2.ORA-27300: OS system dependent operation:CreateThread failed with status: 8
问题3.ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
问题4.ORA-27302: failure occurred at: ssthrddcrTue Sep 22 14:29:46 2009
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\ora7\ora7\trace\ora7_psp0_356.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Tue Sep 22 14:29:47 2009
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\ora7\ora7\trace\ora7_cjq0_2940.trc:
问题5. 找不到这个文件 ora7_cjq0_2940.trc:
问题6. 在ora7_psp0_356.trc中,信息如下:
*** 2009-09-22 15:01:31.128
Process startup failed, error stack:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr请问以上问题该怎么解决,需要修改哪些配置?
cup是双核4路,内存为16G。
数据库是oracle11g标准版。
sga信息如下:
NAME TYPE VALUE
------------------------------------ ------- ----------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size unknown 1468006400
sga_target unknown 0Total System Global Area 1464717312 bytes
Fixed Size 1349824 bytes
Variable Size 511706944 bytes
Database Buffers 947912704 bytes
Redo Buffers 3747840 bytesmemory_max_target 为2G
memory_target 为2047M
最大上限pga为220M
最大可分配pga为200M具体出现的问题症状描述如下:
问题1.ORA-04030 out of process memory when trying to allocate 1049100 bytes (kxs-heap-w,kllcqgf:kllsltba)
问题2.ORA-27300: OS system dependent operation:CreateThread failed with status: 8
问题3.ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
问题4.ORA-27302: failure occurred at: ssthrddcrTue Sep 22 14:29:46 2009
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\ora7\ora7\trace\ora7_psp0_356.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Tue Sep 22 14:29:47 2009
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\ora7\ora7\trace\ora7_cjq0_2940.trc:
问题5. 找不到这个文件 ora7_cjq0_2940.trc:
问题6. 在ora7_psp0_356.trc中,信息如下:
*** 2009-09-22 15:01:31.128
Process startup failed, error stack:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr请问以上问题该怎么解决,需要修改哪些配置?
SQL> show parameter hash_area_size;NAME TYPE VALUE
------------------------------------ ------- ------------------------------
hash_area_size integer 131072补充sort_area_size大小
SQL> show parameter sort_area_size;NAME TYPE VALUE
------------------------------------ ------- ----------
sort_area_size integer 65536
ORA-27301: OS failure message: string
Cause: OS system call error
Action: contact Oracle SupportOracle 11G 有 for win 2008版本的了吗? 楼主在安装过程中有没有出现错误? 估计是系统和数据库版本不兼容造成的..
memory_max_target 为2G
memory_target 为2047M
是怎么得到的?我看你的是
SGA_MAX_SIZE:1468006400/1024/1024/1024=1.37g
PGA如果是220m的话
最大内存使用为1.37+0.22≈1.6g