Thanks for the answer Steve.
- Steve Adams <steve.adams_at_ixora.com.au> escribió: >
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-----
> From: Pablo ksksksk [mailto:p_rodri99_at_yahoo.es]
> Sent: Thursday, 5 April 2001 0:26
> To: Multiple recipients of list ORACLE-L
> Subject: Enqueue waits
>
>
>
>
> 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).
>
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).
Received on Fri Apr 06 2001 - 11:27:21 CDT
