Re: DB Slow down
- From: Mogens Nørrgaard <mln@xxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Dec 2005 02:17:16 +0100
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 <http://9.2.0.6>
OS : solaris 8
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar@xxxxxxxxx <mailto:to_onkar@xxxxxxxxx>
onkarnath.tiwary@xxxxxxxxx <mailto:onkarnath.tiwary@xxxxxxxxx>
- References:
- DB Slow down
- From: Onkar N Tiwary
Other related posts:
- » Re: DB Slow down
- » DB Slow down
- » Re: DB Slow down
- » Re: DB Slow down
- » Re: DB Slow down
Onkar N Tiwary wrote:
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 <http://9.2.0.6>
OS : solaris 8
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar@xxxxxxxxx <mailto:to_onkar@xxxxxxxxx>
onkarnath.tiwary@xxxxxxxxx <mailto:onkarnath.tiwary@xxxxxxxxx>
- DB Slow down
- From: Onkar N Tiwary