Archive and checkpoint settings?

[Unna]

Good morning all! Our database is archiving at every 6 seconds. Can anyone suggest why and how can we reduce the frequency? We have log_checkpoint_interval = 3000000 and log_checkpoint_timeout = 0. Thanks!

[gandhi]

HI,

shutdown the database
Increase the time in log_checpoin_interval in initfile
restart the database

Then see the performance.

bye
gandhi

[Unna]

Tried that but didn't work. We don't have many users currently using the database, there shouldn't be that much to archive. Any suggestion? Thanks!

[sudip]

Try Increasing the size of yr log file and also increase log_checkpoint_interval parameter.

[rmgirma]

Increase the size of your redo log files.
What's your current redo log file size? Is it less than 3 Meg ?

[Unna]

Thanks, I will try to increase them. We have 5 redo log groups each with 3M.