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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).