How many redo log files?

How can I know how many redo log files are enough for a database that receives 65,000 transactions per minute and how large should they be?

How can I know how many redo log files are enough for a database that receives 65,000 transactions per minute and how large should they be?

The only real way is to watch your online redo logs in action and use that information to size them appropriately. But I can make some recommendations.

First, start with five redo log groups. A good size I use is 100 MB in size for each group. Then, watch your database in action. You should not see any "checkpoint not complete" messages in your Alert Log. If you do, consider increasing the size of your online redo log groups. I recommend switching the online redo logs no quicker than once every five minutes. If the online redo log groups switch more often than that, you will need to increase the size of the groups. I also like my groups to switch more often than once an hour for non-quiet times. So if you are not switching often enough, consider reducing the size of your online redo logs.

Dig Deeper on Oracle DBA jobs, training and certification

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close