各位老师好：
一台单实例数据库，25，26，28 三天，每天被pmon进程直接杀死实例，在trc文件中没有看到是什么造成的这个问题。能帮忙分析一下，这个是什么情况吗？谢谢啦
Thu Jul 25 19:30:52 2019
PMON (ospid: 14099): terminating the instance due to error 490
Thu Jul 25 19:30:52 2019
System state dump requested by (instance=1, osid=14099 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /home/oracle/app/diag/rdbms/itsom/itsom/trace/itsom_diag_14109_20190725193052.trc
Dumping diagnostic data in directory=[cdmp_20190725193052], requested by (instance=1, osid=14099 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 14099
Thu Jul 25 00:26:07 2019
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [8.34%] pct of memory swapped out [1.18%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
Thu Jul 25 14:51:47 2019
以上信息提示swap不足。怀疑是内存不足，可检查方向：
1，主机内存使用情况
2，检查db的sga配置，及主机是否开启hugepage。
评论
有用 0
墨值悬赏