X-list: oracle-l Return-Path: Subject: DB Slow down From: Onkar N Tiwary Message-id: a144e5210512251658r1fb5fd4eic5caf510d8b42e69@mail.gmail.com Date: 2005-12-26 01:58:25 hi all, My database is in cluster but that is os level cluster and for database some resource groups have been created.we had switched our server from no archive to archive log mode on saturday but on sunday night while doing the schedule job of bulk data loading , the performance of the server went down. My seniors asked me to revert to noarchive which i did also but then also the performance was pathetic. Any idea? DB : oracle 9.2.0.6 OS : solaris 8 -- Thanks & Regards, T. Onkar Nath OneAPPS Enterprise Technology Pvt. Ltd. to_onkar@yahoo.com onkarnath.tiwary@gmail.com