Re: archive logs

Check log_checkpoint_interval in init<sid>.ora It should greater than or equal to the size of your redolog files. The unit is O/S blocks, usually 512 bytes. The default is 10000.
Most likely your redolog files are only filled half. Of course you need to bounce the database after changing init<sid>.ora

Hth,

Sybrand Bakker, Oracle DBA

noams_at_ncc.co.il wrote:

> I'm sorry if you get this twice (lousy connection)
>
> My database is working in archive mode (automatic)
> I have 4 online redo log groups each 10MB and my database holds heavy
> transactions.
>
> My problem is that the database is switching it's log file each minute!
> that means my database is producing 10MB of archive each minute.
>
> Although it makes alot of big transactions, I'm not sure that the reason the
> log files are switched is becuase they are full (maybe cause of some other
> reason).
>
> Anyhows, if I DO have to keep up writing 10MB of archive each minute then when
> can i delete them (I'm performing a hot backup each night 00:00)
>
> Thanks in advance
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Wed Mar 03 1999 - 11:52:13 CST