从AWR可以看出主机内存只有8G,给到数据库的memory_target只有3G(SGA+PGA),再从ALERT日志可以看到一直再报ORA-4030内存不足的错误:Thu Jul 12 22:00:11 2018
Errors in file e:\app\administrator\diag\rdbms\\\trace\_j002_11356.trc (incident=10272):
ORA-04030: out of process memory when trying to allocate 131104 bytes (kxs-heap-w,bucket:qesandvSynopses)
Incident details in: e:\app\administrator\diag\rdbms\\\incident\incdir_10272\_j002_11356_i10272.trc
Errors in file e:\app\administrator\diag\rdbms\\\trace\_j002_11356.trc (incident=10273):
ORA-04030: out of process memory when trying to allocate 824504 bytes (pga heap,kco buffer)
ORA-04030: out of process memory when trying to allocate 131104 bytes (kxs-heap-w,bucket:qesandvSynopses)
再加上Windows平台非常容易产生碎片,迟早会出现宕机的情况。
建议:
1、停掉主机上其他非数据库程序,将memory_target扩大到6G
2、扩大主机内存
3、如果近期无法增加内存,建议定期重启Windows主机和Oracle数据库(一般一周或者一个月)。