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: Oracle 10g

RE: Oracle 10g

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Fri, 25 Nov 2005 14:00:51 -0500
Message-ID: <42BBD772AC30EA428B057864E203C999041FF7DE@MSGBOSCLF2WIN.DMN1.FMR.COM>


It was always producer/consumer relationship using IPC. I just started looking at Oracle 10 yesterday, time to do some research :)

I was hoping for a short cut:)

-----Original Message-----

From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl] Sent: Friday, November 25, 2005 1:57 PM
To: Khedr, Waleed
Cc: 'oracle list'
Subject: RE: Oracle 10g

I didn't play with parallel execution in 10g yet, so I have to ask for some consideration here :-) but I guess anything *not* revealed by the // execution plan is implemented using IPC between the QC/consumer/producer processes ...

additions/corrections most welcome,

Lex.  



Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html

So how does each slave determine the part of the data or the sub-function that
it needs handle?

-----Original Message-----

Waleed,

no, Oracle is *not* hiding things here -- as Christian says, the slave processes *do* share the same cursor in 10g.

this is a great new feature, especially for Oracle development itself ;-)
because from now on they don't need to maintain the "Slave SQL generator" code anymore with every new release of the kernel, which became more and more tedious and time consuming.

-----Original Message-----

Oracle probably just decided to hide this layer!!

-----Original Message-----

There's no workaround because it simply run like this in 10g, i.e. coordinator and slaves executes the same SQL statement (you probably noticed the new operations in the execution plan as well...).

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 25 2005 - 13:03:00 CST

Original text of this message

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