Re: TUNE DB

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 Timer" a Idle event and Virtual Circuit Status can be a Idle event as
well depending on the arguments.

But to be frank this looks like a db that has nothing to do or a db on a machine with lots cpu's ?
(2552 + 1825 = 4377 hours ~ 182 day's)

Seema Singh wrote:

> Hi
> The following are top5 wiat events in my database?
>
> Total Total Time Avg
> Waits Timeouts Waited % of Wait
> Event Name (in 1000s) (in 1000s) (in Hours) Concern (Secs)
> -------------------------- ----------- ----------- ----------- -------
> virtual circuit status 8,248.75 282.51 2,552.01 54.95
> dispatcher timer 30,900.42 15,714.38 1,825.41 39.30
> single-task message 26,299.17 50.72 156.76 3.38
> log file sync 3,757.66 15.98 72.02 1.55
> control file parallel writ 702.02 0.00 10.86 0.23
>
> I increase shared server also.Let me know group view what to do please?
> Thx
> -Seema
>
> _________________________________________________________________
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>

-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk

/*
The process of preparing programs for a digital computer is especially
attractive, not only because it can be economically and scientifically
rewarding, but also because it can be an aesthetic experience much like 
composing poetry or music

Donald Knuth
*/ 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).