CODEWITHSUNDEEP
oracle-databaseredo-logs
Snochacz
Snochacz

Reputation: 725

Oracle redologs files

Assuming regular basis workload of the database generates 1GB of data in redologs files every hour. What number and size of the redologs files might be appropriate for a good performance?

Upvotes: 0

Views: 83

Answers (1)

MaxU - stand with Ukraine
MaxU - stand with Ukraine

Reputation: 210832

It's much more interesting how much redo data will be generated during the peak hours! So plan for the peaks, not for the regular workload!

Some DBAs say: size your online redo logs, so that it won't be switched more than 3-6 times per hour during peak times.

And it's better to make it bit bigger (add some buffer for future harder peaks), but make sure that you back them up more often, so that you won't loose too much changes when you will have to do restore and recovery.

You also may want to read this:

Upvotes: 1

Related Questions