Re: huge amount of redo log switches

Check the value of
log_checkpoint_interval
log_checkpoint_timeout

The first one is in 512 bytes blocks (O/S blocks?) and it should be greater than or equal to the size of your online redo log files. If log_checkpoint_interval is set, log_checkpoint_timeout should be zero. This parameter determines how often Oracle will perform a checkpoint in minutes.

Also as smeone else posted, check your alter log file.

2 G redo log per day is IMO not unusual. a checkpoint every 3 mins is.

Hth,

Sybrand Bakker, Oracle DBA

<susana73_at_hotmail.com> wrote in message news:8mmr4g$arp$1_at_nnrp1.deja.com...
> Hello,
>
> I have a problem on my development database. It's generating huge
> amount of redo log switches CONSISTENTLY which give me a large amount
> of archive logs(2GB a day). Why I say consistent is because it starts
> generating at 7am to 5pm on every 3 minutes basis EVERY DAY.
>
> It's a very small database(only 1GB) with multiple schemas and the only
> users are developers. log_buffer=32768 and two sets of redo logs each
> 4M. I've asked my developers and none of them say they have a job
> running since 7am every day. And I don't think there is any large batch
> job because it's a development db.
>
> I tried resizing(increasing and decreasing) log_buffer and redo log file
> size but it doesn't help. I think I need to identify the db
> transactions which are responsible for all those redo logs.
>
> 1GB database with 2GB archive logs doesn't make sence to me! Any help
> is appreciated!
>
> Susana
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Aug 07 2000 - 00:00:00 CDT