Re: Help: huge amount of redo log switches

Hello,

There must be some sort of activity to generate the redo logs. Check against

the v$session to see if there are any active session and if there are join it to
v$sqlarea to find out the SQL. You could try having a look at V$transaction as transactions which are doing updates will have an entry in this table. If you are using oracle 8i you could switch monitoring on 'alter table xxxx monitoring' and the following morning check the dba_tab_modifications table; this will tell you which tables have been updated.

With regards to the amount of redo generated, do you have many indexes in the system ?

SH

susana73_at_hotmail.com wrote:

> 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 Tue Aug 08 2000 - 00:00:00 CDT