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

SQL Queries for Goldengate Replications

  set linesize 200 set pagesize 100 set trimspool on column table_owner format a25 heading 'TABLE_OWNER' column tabl...