Re: RAC partitioning idea bounce
Date: Mon, 09 Sep 2013 18:08:53 +0200
Message-ID: <522DF295.1090402_at_usn-it.de>
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.
Regards
Martin
Walker, Jed S schrieb:
> Hi All,
> I have a system on 11.2.0.3 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 http://www.usn-it.de -- Usn's IT Blog for Oracle and Linux http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 09 2013 - 18:08:53 CEST