If yes, have you tested this query without Parallel Query?
If no, where did I misunderstand you?
Best regards,
Mogens
Ravi Kulkarni wrote:
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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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).