Q
Problem solve Get help with specific problems with your technologies, process and projects.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close