Quote Originally Posted by ladiesman View Post
Configuration: hp-ux OS, oracle 10g, SAP 6.4,
size of archive log files is too high 18GB for a day. Logs are created 2 times in a day in interval of 12 hrs, I need to decrease the maximum size for archive log files?
Best thing for you to do would be to analyze the redo generation trend of your database and then set redo log size and number of log groups accordingly.