Archived LOgs issue [message #53351] |
Sat, 14 September 2002 22:58 |
Anu
Messages: 82 Registered: May 2000
|
Member |
|
|
Frequent Archive logs creation
Hi,
We have a database running in Archive Mode (24 * 7). My issue is the activities in these database is normal. Inspite of this the Archive logs are created frequently. Each Archive Logs are of size 25M. I found that the time span between each archive log files is 2.5 hours. What is the reason for this frequent logs creation. Is there any parameter setting to be changed to control this. It is eating a lot of our harddisk space.
Kindly throw some light to this issue.
Thanks in advance.
Anu.
|
|
|
Re: Archived LOgs issue [message #54711 is a reply to message #53351] |
Fri, 29 November 2002 16:16 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Redo logs are generated because there are DML operations going on in your db. You can avoid generation of redo logs for some DDL operations, but for DML there will be still redo logs. If you are running in archivedlog mode, redo logs have to be archived by ARCH, once written by LGWR.
See which operations doesn't generate redo logs from NOLOGGING
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|