(?) PX Event Timeouts without using parallel query (?)

From: Davide Bellesi <davide.bellesi_at_visto.com>
Date: Thu, 07 Sep 2000 03:39:46 -0700
Message-Id: <10612.116384@fatcity.com>

Hi, I would like to have an answer for a problem.

My query experienced a lot of timeouts on PX events even if I didn't use = parallel query (no parallel hint and degree=3D1 on tables involved) :

EVENT                          TOTAL_WAITS TOTAL_TIMEOUTS
------------------------------ ----------- --------------
latch free                              59             55
enqueue                                 46             41
free buffer waits                       12             11
PX qref latch                            6              1
PX Deq Credit: send blkd               117             54
PX Deq: Signal ACK                       4              4
PX Deq: Execute Reply                 1314            680

Ps. I'm using Oracle 8.1.5 on HP-UX

Can you help me ??

Thanks in advanced
Davide
_________________________________________________________________________=
__

Visit http://www.visto.com/info, your free web-based communications cente= r.
Visto.com. Life on the Dot. Received on Thu Sep 07 2000 - 05:39:46 CDT