How Many Redo Log Switches Per Hour


If Redo Log Switch count is too much, you can increase the redo log sizes if you need.

However, the larger the Redo Log, the longer the recovery time.

With the help of the following script, you can see the number of redo log switches on a hourly basis for a database.


If you want to learn more about redo log you should read below articles

Oracle Redo Log And Archive Log“.

How To Change the Size of Redo Log Files

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *