What is a appropriate size for a redo log file?
I understand that a too small redo log file will cause lots of log switching and disk wrting which reduces server performance. What are the drawbacks of a too large redo log file? Is there a rule of thumb in figuring out the file size?
Thanks,
Simon