ERP应用在17:25左右卡住,前台页面刷新无反应.大概十分钟后恢复
数据库查询阻塞如下:

期间的告警日志如下:
Wed Dec 11 16:53:01 2019
Incremental checkpoint up to RBA [0x2a5.202e21.0], current log tail at RBA [0x2a5.212766.0]
Wed Dec 11 17:13:16 2019
Incremental checkpoint up to RBA [0x2a5.22aec6.0], current log tail at RBA [0x2a5.23b3a8.0]
Wed Dec 11 17:22:20 2019
Thread 1 cannot allocate new log, sequence 678
Private strand flush not complete
Current log# 3 seq# 677 mem# 0: /mnt/erpdb/db/apps_st/data/log3a.dbf
Wed Dec 11 17:30:16 2019
minact-scn: useg scan erroring out with error e:12751
Wed Dec 11 17:32:31 2019
ALTER SYSTEM SET parallel_max_servers=16 SCOPE=BOTH;
Wed Dec 11 17:34:17 2019
Incremental checkpoint up to RBA [0x2a5.261555.0], current log tail at RBA [0x2a5.3ef5df.0]
Wed Dec 11 17:36:20 2019
Beginning log switch checkpoint up to RBA [0x2a6.2.10], SCN: 6046310557548
Thread 1 advanced to log sequence 678 (LGWR switch)
Current log# 4 seq# 678 mem# 0: /mnt/erpdb/db/apps_st/data/log4a.dbf
Wed Dec 11 17:38:30 2019
Completed checkpoint up to RBA [0x2a6.2.10], SCN: 6046310557548

期间有些sql查询也卡住没有返回值

数据库是测试用的,安装在OpenStack平台上

感觉和检查点或日志切换有关,我昨天调大了redo日志(1G-2G),加大了logbuff(10M-100M).

这个问题不知道还能从哪里解决?希望专家给出建议或处理意见

谢谢