Re: RAC partitioning idea bounce
- From: Martin Klier <usn@xxxxxxxxx>
- To: Jed_Walker@xxxxxxxxxxxxxxxxx
- Date: Mon, 09 Sep 2013 18:08:53 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: