-
Managing archive log size
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
procedure for reducing archive log size.
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.
-
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
Last edited by hrishy; 09-30-2009 at 03:18 AM.
-
![Quote](images/misc/quote_icon.png) Originally Posted by ladiesman
... how can I analyze the problem behind this huge log files.
Please read again Dave's post... let me quote: "archive logs are the same size of your redo logs".
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
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.
-
![Quote](images/misc/quote_icon.png) Originally Posted by ladiesman
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|