out of memory

显示全部楼层 · 2007-9-26 18:42:10

数据库最近总是被自动关闭，重启时报out of memory
alert文件中的错误为：
ORA-00600: internal error code, arguments: [1100], [1977039912], [1977039912], [], [], [], [], []
Fri Jun 18 14:26:27 2004
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 2119
请大侠指点。

千问 · 2007-9-26 18:42:10

再给点其它信息，不如机器配置，sga，pga参数设置，连接用户数等等。凭ORA-00600不能定位问题的。

千问 · 2007-9-26 18:42:10

机器配置：hpN4000，4G MEMORY，OS:HPUX11.0
+oracle8.1.7
SVRMGR> startup;
ORACLE instance started.
Total System Global Area
2735274712 bytes
Fixed Size
96984 bytes
Variable Size
762945536 bytes
Database Buffers
1966080000 bytes
Redo Buffers
6152192 bytes
init主要参数：
open_cursors = 100
max_enabled_roles = 30

db_block_buffers = 150000
shared_pool_size = 800000000
large_pool_size = 26144000
java_pool_size = 0
log_checkpoint_interval = 900000000
log_checkpoint_timeout = 0
processes = 50
log_buffer = 8000000
rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 5
job_queue_interval = 60
distributed_transactions = 100
open_links = 4
compatible = "8.0.5"
sort_area_size = 1024000
sort_area_retained_size = 165536

千问 · 2007-9-26 18:42:10

shared_pool_size = 800000000 太大了
processes = 50好象有点小，不知同时有多少台机器连到服务器

千问 · 2007-9-26 18:42:10

PGA多大?

千问 · 2007-9-26 18:42:10

把trace文件传上来看看
另外，数据库异常关闭后重启报out of memory可能是share memory没有释放掉

千问 · 2007-9-26 18:42:10

没错，数据库shut后杀了剩余的进程后就可以启动了。

千问 · 2007-9-26 18:42:10

bug959593,升级到8163吧