Exadata log switches twice in every hour however archive_lag_target=0
Hi
Oracle 19.16, exadata
I am playing around with exadata (image 22.1), and I have noticed something strange.
I can see that log switches are occurring at least twice per hour, so seems like the below parameter is set to 1800, but it is not.
SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> show parameter archive_lag_target NAME TYPE VALUE -------------------------------------------------- archive_lag_target integer 0
Log switches:
Although, this behavior (at least 2 log switches per hour) is welcomed, my question is, what triggers these log switches..?
Regards
Raul