What should the Oracle Redo Log block size be set to in order to prevent...

The Oracle Redo Log block size is recommended to be set to 8 kB.This is based on the best practices for Oracle 19c Database, where it was found that increasing the size of the Oracle redo logs can improve database performance12. However, it’s important to note that not every workload will show significant performance increase when increasing the size of the redo logs. Customers should evaluate the AWR to determine if the redo logs have an associated high number and duration of wait times.If the redo logs show a possible bottleneck, then increasing the size of the redo logs could improve performance2.