GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID ------ ------- --------- ----------- --------- ------- --------------- --------------- ------------- --------- -------------------- --------- ------ 1 1 21 52428800 512 2 YES INACTIVE 944581 23-NOV-20 1046277 25-NOV-20 0 2 1 22 52428800 512 2 YES ACTIVE 1046277 25-NOV-20 1062021 26-NOV-20 0 3 1 25 52428800 512 2 NO CURRENT 1062027 26-NOV-20 281474976710655 0 4 1 23 104857600 512 1 YES ACTIVE 1062021 26-NOV-20 1062024 26-NOV-20 0 5 1 24 104857600 512 2 YES ACTIVE 1062024 26-NOV-20 1062027 26-NOV-20 0 SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID ------ ------- --------- ----------- --------- ------- --------------- --------------- ------------- --------- -------------------- --------- ------ 1 1 26 52428800 512 2 YES INACTIVE 1062049 26-NOV-20 1062054 26-NOV-20 0 2 1 27 52428800 512 2 YES INACTIVE 1062054 26-NOV-20 1062057 26-NOV-20 0 3 1 25 52428800 512 2 YES INACTIVE 1062027 26-NOV-20 1062049 26-NOV-20 0 4 1 28 104857600 512 1 YES INACTIVE 1062057 26-NOV-20 1062060 26-NOV-20 0 5 1 29 104857600 512 2 NO CURRENT 1062060 26-NOV-20 281474976710655 0 SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$