RE: Enqueue waits

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 04 Apr 2001 16:33:56 -0700
Message-ID: <F001.002E1EB4.20010404163024@fatcity.com>

Hi Pablo,

The TM and TX waits are probably normal application tuning issues. You'll find some tips about reducing ST enqueue waits on the Ixora web site, MetaLink and elsewhere. The CU and SQ waits are relatively few and probably relatively brief, nevertheless there can be performance issues with these but I would focus on the others first. In general, the Anjo Kolk paper on "Oracle7 Wait Events and Enqueues" is the best starting point for information about different enqueue types. You can find it at http://www.evdbt.com/event.pdf

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
Sent: Thursday, 5 April 2001 0:26
To: Multiple recipients of list ORACLE-L

Hi List.

Enqueue waits is on the TOP of my wait list.

Event     time_waited       average_wait
-----     -----------       ------------
enqueue    2168559            6396.93

Here are the details:

TY GETS WAITS
-- --------- ---------

CF       104         0
CI     10788         0
CU     25388         7
DL       259         0
DR       149         0
DX     56457         0
IS       180         0
MR       130         0
RT         1         0
SQ      2660         3
ST     10078       221

TY      GETS     WAITS
-- --------- ---------
TM    398703         5
TS     13669         0
TX    288025       116
UL      4923         0
US     43960         0
WL        16         0

This is a Oracle Financials application I'm tuning.

Can anybody explain what these types of ENQUEUE mean? And how can I avoid them.

TIA

Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: p_rodri99_at_yahoo.es

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

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 Wed Apr 04 2001 - 18:33:56 CDT