Re: DB Slow down

From: Mogens Nørrgaard <mln_at_miracleas.dk>
Date: 2005-12-27 02:17:16
Message-id: 43B0961C.6070509@miracleas.dk

Only one real idea or suggestion: If you don't know where the time was spent before the problem started, you'll have a hard time now spotting the difference. Trace, trace, trace.

Mogens

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 Tue Dec 27 2005 - 02:17:16 CST