Managing archive log size [message #423973] |
Tue, 29 September 2009 13:16 |
ladiesman
Messages: 2 Registered: September 2009 Location: India
|
Junior Member |
|
|
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, how do I do?
|
|
|
|
Re: Managing archive log size [message #424183 is a reply to message #423973] |
Wed, 30 September 2009 08:22 |
ladiesman
Messages: 2 Registered: September 2009 Location: India
|
Junior Member |
|
|
so how do I analyze the reason behind such a disaster...we are planning to copy log files on DR (Disaster Recovery) site, but 18GB in a day is too much to transfer through lease line. I'm basically SAP consultant but I need to get with this issue.....
In what way I can reduce redo log size, we have 200 SAP users.
is this related to bad SQL programming or something to analyze in database.......any tool which can be useful for this problem.
We are using HP Data Protector to schedule database backup.
|
|
|
Re: Managing archive log size [message #424188 is a reply to message #424183] |
Wed, 30 September 2009 08:43 |
|
Michel Cadot
Messages: 68704 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Amount of redo is directly related to number & "size" of DML against DB.
Search what are the DML and analyze if they are all necessary.
For instance, do not update all fields if you need to update one field, do not execute N update to update N fields of the same row, do not delete/insert instead of update, do not insert/modify a row if you will delete it soon...
In short, do less work.
Regards
Michel
|
|
|