Hi, Did you perform a 10046 trace of the load? Best Regards Srriam Kumar On 12/25/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote: > > 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@xxxxxxxxx > onkarnath.tiwary@xxxxxxxxx > >