Thanks Mogens,
It works great with no parallelism set.
But when parallelism is set to DEFAULT it fails
(intermittently). The tables are imported from a
Non-Rac production environment.
Found a note on Metalink last night which says DEFAULT
is calculated as : CPU_COUNT*PARALLEL_THREADS_PER_CPU
and DOP is DEFAULT * INSTANCES.
The DOP it was using was 48 (6 cpus*4 thr/cpu*2
instances)
This is the same setting in Production(infact with
more cpus and hence larger DOP) but has been running
fine. I guess the issue is magnified due to slaves
being spawned at the other node and the QC sync'ing
with them. I see huge number 'IPC send completion
sync' events during this time.
I had to alter degree from 'Default' to 2 for some
tables and disable parallelism to smaller lookup
tables to get it working. These went unnoticed in a
single instance box.
Thanks,
Ravi.
- Mogens_Nørgaard <mln_at_miracleas.dk> wrote:
> 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).
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).
Received on Tue Sep 16 2003 - 11:04:42 CDT
