LGWR switch happening frequently
Hi, in my alert_orcl.log file I'm seeing a lot of LGWR switch messages. I've Googled and searched this forum and the result is primarily just "find the program causing it" but I'm not sure what would result in the log switching to happen.
alert_orcl.log
2021-10-25T11:35:10.335838-04:00 Thread 1 cannot allocate new log, sequence 15292 Private strand flush not complete Current log# 3 seq# 15291 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_3_j4dx3spf_.log Current log# 3 seq# 15291 mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_3_j4dx3sy6_.log 2021-10-25T11:35:13.348819-04:00 Thread 1 advanced to log sequence 15292 (LGWR switch) Current log# 1 seq# 15292 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_1_j4dx3so6_.log Current log# 1 seq# 15292 mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_1_j4dx3ssw_.log 2021-10-25T12:47:09.418954-04:00 Thread 1 advanced to log sequence 15293 (LGWR switch) Current log# 4 seq# 15293 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_4_jovynwbz_.log Current log# 4 seq# 15293 mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_4_jovynwdz_.log 2021-10-25T13:00:12.190819-04:00 Thread 1 cannot allocate new log, sequence 15294 Private strand flush not complete Current log# 4 seq# 15293 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_4_jovynwbz_.log Current log# 4 seq# 15293