Exadata General (MOSC)

MOSC Banner

Exadata log switches twice in every hour however archive_lag_target=0

edited Aug 17, 2022 8:02AM in Exadata General (MOSC)

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

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