Site icon Database Tutorials

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

Exit mobile version