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?
Printable View
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?
archive logs are the same size of your redo logs
if you really have 9gb redo log files, then you have bigger problems
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,
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 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.Quote:
what is the step by step procedure for reducing MAX size of redo logs.
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,
Can the op please confirm you have 9gb redo log files really ?
even if you have 9gb redo log files and say you have set parameter
ALTER SYSTEM SET ARCHIVE_LAG_TARGET = 600 SCOPE=BOTH;
This sets the maximum lag to 10 mins.
regards
Hrishy