Re: DB Slow down

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: 2005-12-26 15:23:38
Message-id: c515faee0512260623j23e60b9fh173a5d20bf9f1c89@mail.gmail.com

Hi,

Did you perform a 10046 trace of the load?

Best Regards

Srriam Kumar

On 12/25/05, Onkar N Tiwary 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_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
>
Received on Mon Dec 26 2005 - 15:23:38 CST