Re: TUNE DB

2002-05-30 Thread Peter Gram
Hi Seema The radical thing to do is to turn off MTS for a start ! Why are you using MTS ? You are not giving a lot of information on the db ? To be able to give a proper answer we need to know how many days this db have been up running. Is there a problem ? As fare as I remember is "Dispatcher

TUNE DB

2002-05-30 Thread Seema Singh
Hi The following are top5 wiat events in my database? Total TotalTime Avg WaitsTimeouts Waited% of Wait Event Name (in 1000s) (in 1000s) (in Hours) Concern (Secs) ---