RE: Wait Event "queue messages"

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 04 Oct 2002 05:48:21 -0800
Message-ID: <F001.004E0973.20021004054821@fatcity.com>

This is related to the AQ mechanism and can be ignored. Oracle posts this wait while waiting to dequeue a message from AQ queue.

To remove it from the 'Top 5' list in statspack report, you can add a row to perfstat.stats$idle_event table. And while at it, you may want to review what other waits statspack considers as idle waits and doesn't report in the Top 5 list. But, you may want to know about some of those...

Check Oracle8i Reference Guide for this and all other wait events and more.. :)

• Kirti

-----Original Message-----
Sent: Friday, October 04, 2002 6:08 AM
To: Multiple recipients of list ORACLE-L

Qs Is Wait Event "queue messages" any Cause for Concern ? Qs If so What is the Resolution for the Same ?

Qs Any Links , Docs for the Same ?

Top 5 Wait Events

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

Time

-------------------------------------------- ------------ ------------
-------
queue messages                                      1,063    1,066,954
58.16
db file scattered read                          1,937,704      408,204
22.25
latch free                                         66,364      212,801
11.60
buffer busy waits                                  57,849       98,834
5.39
db file sequential read                         1,531,718       25,079
1.37
          -------------------------------------------------------------

Thanks
--

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

Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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).
--

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

Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Fri Oct 04 2002 - 08:48:21 CDT