ID This Wait stat

From: Tom Schruefer <tschruefer_at_mail.howard.k12.md.us>
Date: Tue, 21 May 2002 12:32:05 -0800
Message-ID: <F001.00466831.20020521123205@fatcity.com>

You know I could have all the documentation for Oracle printed on my brain, buy all the books ever written about the subject, but the primary wait problem that comes up will never be directly addressed.

So, what exactly does 'Slave Wait' mean and what can I do about it?

I am using DBWR Slaves, since it did not seem as though starting additional DBWR's was appropriate on a Win2000 system.

Here are the Top 5 wait events as per Statpack and my shinny new 'Oracle Performance Tuning 101' book:

Top 5 Wait Events

~~~~~~~~~~~~~~~~~                                             Wait     %
Total
Event                                               Waits  Time (cs)   Wt

Time
-------------------------------------------- ------------ ------------ -----
--

slave wait                                         66,593    6,793,939
88.85
PX Deq: Execution Msg                              28,960      407,167
5.33
PX Deq: Table Q Normal                             19,864      302,480
3.96
PX Deq Credit: send blkd                            3,685      123,671
1.62
PX Deq: Signal ACK                                  3,214        5,294

.07

I have a pretty good idea that 2-5 are for parallel query option, although I still have to figure out just what they mean.

Any help would be greatly appreciated.

---

Tom Schruefer - tschruefer_at_mail.howard.k12.md.us 410-313-6825

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tom Schruefer
  INET: tschruefer_at_mail.howard.k12.md.us

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). Received on Tue May 21 2002 - 15:32:05 CDT