Re: Partitioning tables reduces inter-instance block contention in RAC installations?

Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioning tables reduces inter-instance block contention in RAC installations?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 22 Oct 2003 13:43:34 GMT
Message-ID: <aQvlb.506$1W1.205@news02.roc.ny>

"Carey" <carey_42_at_hotmail.com> wrote in message news:cda0caec.0310210617.2849f25_at_posting.google.com...
> Chapter 3 of the Oracle 9i (Release 1) Real Application Clusters
> Deployment and Performance guide contains a section on reducing the
> overhead involved with inter-instance communication over the
> high-speed interconnect when one RAC instance attempts to retrieve a
> block that is "mastered" by another instance.
>
> The section mentions that one way to do this is by implementing table
> partitioning by range. However I don't understand how this works.
>

--snip--

In the documentation it states that this technique applies to single instance envs also.

Don't get all confused trying to put an RAC specific spin on this advice.

Anurag Received on Wed Oct 22 2003 - 08:43:34 CDT