Re: RAC partitioning idea bounce

From: Martin Klier <>
Date: Mon, 09 Sep 2013 18:08:53 +0200
Message-ID: <>

Hi Jed,

do you have achance to test it on a RAC? Would be interesting to know what wait events are the result. Because I'm not sure what hash magic and dictionary operations may cause.

Marks idea with partitioning by node sounds cool for the concept as well.


Walker, Jed S schrieb:
> Hi All,
> I have a system on 4-node RAC that I'm trying to help with. They have a process that inserts rows into a table. A database job then takes those rows and processes them into another table. There is a service configured on the RAC so that the inserting applications only connect to one RAC instance because they say the contention is too great when running across all nodes. I'm figuring the contention is due to all 4 nodes trying to insert into the same segment.

Usn's IT Blog for Oracle and Linux

Usn's IT Blog for Oracle and Linux

Received on Mon Sep 09 2013 - 18:08:53 CEST

Original text of this message