| Frequent Archived logs creation [message #53350] |
Sat, 14 September 2002 22:43  |
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: Frequent Archived logs creation [message #53362 is a reply to message #53350] |
Mon, 16 September 2002 01:04  |
K.K. Raj kumar
Messages: 33
Registered: July 2002
|
Member |
|
|
Check up the parameter
log_checkpoint_interval.. if this interval is very low then DBWR will be invoked repeatedly and inturn calls LOGWR.
You can also see the Alert files and Trace files to see what is the other problems Oracle is facing.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
