Pls can someone explain to me why my oracle 8i database generates 20 .arc archive files in less than 3 minutes. Its has never happenned before and at a point users will not be able to logon to the database any more and they get ora-00257: archiver error. Connect internal only, until freed. When this error occurs i delete some of the .arc files.
How can i stop this error and also how can i detect the process causing this problem to possibly stop it.