oracle文档解释:
Waiting for a log switch because the session cannot wrap into the next log. Wrapping cannot be performed because the checkpoint for that log has not completed.
查看redo日志信息:
select * from v$log;
select * from v$logfile;
查看切换频率:
select completion_time from v$archived_log order by 1 desc;
发现在系统繁忙时候,日志一分钟会切换好几次。
添加个日志组并将日志大小调整为100m
alter database add logfile group 4 ('D:\APP\ADMINISTRATOR\ORADATA\REDO04a.LOG ','D:\APP\ADMINISTRATOR\ORADATA\REDO04b.LOG ') size 100M;
然后将其它三组redo日志的进行调整:删除已有日志组,然后重建(要将日志组调整到inactive状态后再操作)
alter database drop logfile group 3; alter database add logfile group 3 ('D:\APP\ADMINISTRATOR\ORADATA\REDO03a.LOG ','D:\APP\ADMINISTRATOR\ORADATA\REDO03b.LOG ') size 100M;