Re: RAC Parallel Query Issues

I'm not sure I understand. Is this a query that should access a 470 record table and which uses Parallel Query in a RAC environment? And when it works, it executes in less than a second?

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: mln_at_miracleas.dk

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).