Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAC Parallel Query Issues

RE: RAC Parallel Query Issues

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Tue, 16 Sep 2003 10:44:40 -0800
Message-ID: <F001.005D011B.20030916104440@fatcity.com>


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)
(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: 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-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).
Received on Tue Sep 16 2003 - 13:44:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US