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
-------------------------------------------------------------
~~~~~~~~~~~~~~~~~~ % 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 insttantly with your online friends? Get the FREE Yahoo! Messenger