Forum Stats

  • 3,855,695 Users
  • 2,264,544 Discussions
  • 7,906,141 Comments

Discussions

Excessive redo log switches - Thread 1 advanced to log sequence 21290 (LGWR switch)

Salazkin Ann
Salazkin Ann Member Posts: 129 Silver Badge
edited Jul 10, 2020 7:17PM in Database Upgrade

After upgrade of Oracle db to 12C alert log shows excessive redo log switches:

Thread 1 advanced to log sequence 21290 (LGWR switch)

How properly reset the size of redo log files in order to decrease the switches? What is the advantage?

Answers

  • Dude!
    Dude! Member Posts: 22,830 Black Diamond
    edited Jul 10, 2020 7:17PM

    Is there any error or warning about excessive redo log switches?

    How did you make your judgement or assessment?

    Log switches depend on database changes. Are there any extensive imports or other data changes happening?

    How large are the current redo logs?