Does anyone know what these oracle events are and how the wait times can be reduced. This is an extract from statspack output on 9.2.0.4 on HP 11.11
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
pipe put 780 3,904 44.65
wait for unread message on broadcast channel 3,016 3,034 34.70
PX Deq: Signal ACK 33,937 678 7.76
db file scattered read 6,575,215 499 5.70
PX qref latch 222 200 2.29
-------------------------------------------------------------
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: =?iso-8859-1?q?Zabair=20Ahmed?=
INET: roon987_at_yahoo.co.uk
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 Thu Nov 06 2003 - 07:44:25 CST
