Re: Job taking longer with more RAC nodes

Well spoken. If you have a read-mostly app and/or tight node/user partitioning, you will minimize the necessary communication between nodes that ensures coherency and coordination. But that necessary overhead won't and can't go away, so apps can never run faster on RAC than non-RAC unless something else changes, too (like moving to Opterons, and so forth).

Mogens

john d parker wrote:

>Do you have any degree of parallelism? or is parallel degree set to
>default?
>
>In general, A well behaved app will perform approx the same on RAC
>maybe even marginally slower. A poorly behaved app will absolutely
>stink when moved to RAC. RAC is not a performance enhancing solution.
>
>
>John
>
>

--
http://www.freelists.org/webpage/oracle-l