checkpoint not complete
in the alert log file im seeing a lot of check point not complete which is affecting the DB performance, the redologs are 3 groups each with 2 threads of size 1GB
i have Oracle rac 19c with database 19.3 on linux 7
my archive_lag_target is set to 0
SQL> show parameter archive_lag_target;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
im afraid of increasing the redo logsize more than 1G incase of recovery i would lose a lot, please advice
knowing that the avarage logswitching during peak hours is 6to 8 switches , which is a big number but its a lready 1G