重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-609：疑似MEMORY_TARGET设置过大导致的宕机 [打印本页]

作者: jiawang 时间: 2020-7-23 09:20
标题: ORA-609：疑似MEMORY_TARGET设置过大导致的宕机
ORA-609：疑似MEMORY_TARGET设置过大导致的宕机

现象：
客户的数据库最近发生好几次忽然宕机事件，查看alert日志：
Thu Oct 10 10:47:50 2013
ORA-609 : opiodr aborting process unknown ospid (834_47932399713424)
Thu Oct 10 10:47:50 2013
ORA-609 : opiodr aborting process unknown ospid (740_47613956914320)
Thu Oct 10 10:47:53 2013
ORA-609 : opiodr aborting process unknown ospid (755_47556191542416)
Thu Oct 10 10:47:53 2013
ORA-609 : opiodr aborting process unknown ospid (761_47545590688912)
Thu Oct 10 10:47:54 2013
ORA-609 : opiodr aborting process unknown ospid (859_47653507185808)
Thu Oct 10 10:47:58 2013
ORA-609 : opiodr aborting process unknown ospid (904_47121713061008)
Thu Oct 10 10:48:08 2013
ORA-609 : opiodr aborting process unknown ospid (918_47924605709456)
Thu Oct 10 10:48:16 2013
ORA-609 : opiodr aborting process unknown ospid (965_46996288695440)
Thu Oct 10 10:48:16 2013
ORA-609 : opiodr aborting process unknown ospid (984_47202090368144)
Thu Oct 10 10:49:06 2013
ORA-609 : opiodr aborting process unknown ospid (1103_47027913133200)
Thu Oct 10 10:49:08 2013
Thu Oct 10 10:49:08 2013
ORA-609 : opiodr aborting process unknown ospid (1064_47991325715600)
ORA-609 : opiodr aborting process unknown ospid (1150_47885260754064)
Thu Oct 10 10:50:02 2013
Process W000 died, see its trace file
Thu Oct 10 10:50:17 2013
Process W001 died, see its trace file
Thu Oct 10 10:54:19 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:54:31 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:54:43 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:54:55 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file

分析：
查看启动时的参数设置，发现客户的系统启用了自动内存管理：
memory_target = 21G <-------------Automatic Memory Management feature is used.
free -g查看内存为23G
怀疑主机资源耗尽导致系统宕机，建议客户memory_target设置为16-18G。
调小memort_target之后，之前的自动宕机现象消失。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)