So how does each slave determine the part of the data or the sub-function that it needs handle? -----Original Message----- From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx] Sent: Friday, November 25, 2005 1:37 PM To: Khedr, Waleed Cc: 'oracle list' Subject: RE: Oracle 10g 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. cheers, Lex. --------------------------------------------------------------------- Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html --------------------------------------------------------------------- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Khedr, Waleed Oracle probably just decided to hide this layer!! -----Original Message----- From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx 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...). -- //www.freelists.org/webpage/oracle-l