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)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)
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.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ravi Kulkarni
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
