Disclaimer

Thursday 10 February 2022

Determine the size of Redo file according no of switches per hour in Oracle

For calculating the Size of Redo log file, we can use the following formula:

(Current Switches per hour * Redo Log Size)/(Desired number of Switches)=New redo log size

Example: Suppose we are having 100 M Size of redo log file which switch on an average 10 times in hours and we want to make switch 4 times per hours. For that we can calculate the New Redo log size by using the formula:

Current Switches per hour = 10
Redo log Size = 100 M
Desired number of switches = 4
Calculate New Redo log Size: 10*100/4 = 250M New Size needed for Redo log file to make switches 4 per hours.
Note: 
New Redo Size = (Current Switches per hour * Redo Log Size)/(Desired number of Switches)

No comments:

Post a Comment

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...