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?
if i understand correct total redo generating in a day is 18GB. you can reduce the redo upto some extend by nologging the tables at the risk of loosing data in case of any mishap. It is not recommended in production space.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
what is the step by step procedure for reducing MAX size of redo logs. Also how can I analyze the problem behind this huge log files. We have 200 SAP users
what is the step by step procedure for reducing MAX size of redo logs.
what does it mean? you want to reduce the size of redo log files? reducing redo log size will not reduce the amount of redo generating in a day.
you need to analyze the programing logic of the sql to identify why they are generating more redo. also, if you are using sql*loader use direct path load to stop generating redo.
google it for more options depends on what is running in your machine.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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.
Reply With Quote
Originally Posted by ladiesman
Bookmarks