Archived log files generated too often

[ashley75]

Why did my archiver log generate too often ??? It's like 5 archived log per min, is that b/c my redo log files is too small and I need to increase ???

Please advise

[Sharma]

If your database is heavily transaction oriented and online Redolog files are small you may see this.
Increase the size and see the difference.

[sonofsita]

find out which is generating heavy redo and then control.
Find using

select s.sid,s.serial#,s.username,s.program,i.block_changes
from v#session s, v$sess_io i
where s.sid = i.sid
order by 5 desc,1,2,3,4

If they are caused by stored procs look for the dml statements and if you have no commits introduce etc

[Sureshy]

Has this always been the case, or has this suddenly started happening ?

If it has always been the case, then you need to do some tuning.

If it has suddenly started happening - ask apllication vendor if any change has been made to the application which might cause this and do a detailed performance tuning session, as this may have a knock on affect in other areas.

You can use logminer to find out what is in your redo logs.