Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center