| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAC Parallel Query Issues
Shouldn't happen, but one would have to question the use of PQ on such a
small table anyway. You may be hitting some lower boundary condition that
the developers didn't even look at because the table's so small?
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
Kulkarni
Sent: Tuesday, September 16, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L
We are on 2-Node Rac 9204/Solaris8.
We are having intermittent issues with parallel queries (The table has only 470 records, executes < 1sec otherwise):
SQL> /
select count(*)from eod
*
ERROR at line 1:
ORA-12805: parallel query server died unexpectedly
Trace File has:
kxfp_send_callback
Send timed out to slave 65535 inst 1 (qref
0x63f85fd0)
*** 2003-09-15 18:33:25.034
*** SESSION ID:(63.533) 2003-09-15 18:33:25.034 kxfp_send_callback
Send timed out to slave 65535 inst 1 (qref
0x63fc2004)
kxfplsig
Could not signal error 10388 in server P032 with serial 371201
dp 0x61a822d0, q 0x60f286b0, pr 0x5f457168, cqr 0x63f97584, err 10387
Interrupt Info top=1 size=8 top
err=-2147473260
Query May be hanging.Check V$PX_SESSION
OPIRIP: Uncaught error 12800. Error stack:
ORA-12800: system appears too busy for parallel query
execution
ORA-10387: parallel query server interrupt (normal)
v$px_session : has number of Slave Processes hanging.
Truss for process on
Instance 1:
door_return(0x00000000, 0, 0x00000000, 0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
Err#62 ETIME
read(0, 0xFE6C35E4, 1024) (sleeping...) signotifywait() (sleeping...)door_return(0x00000000, 0, 0x00000000, 0)
Instance 2:
poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 poll(0x02FF15CC, 2, 0) = 0 poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 poll(0x02FF15CC, 2, 0) = 0 poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0
Any inputs would be greatly appreciated.
Thanks,
Ravi.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni INET: nandagokul_at_yahoo.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: peter.sharman_at_oracle.com 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-LReceived on Tue Sep 16 2003 - 13:44:40 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |