Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Charan.

Asked: October 27, 2020 - 4:14 am UTC

Answered by: Connor McDonald - Last updated: October 28, 2020 - 6:18 am UTC

Category: Database Administration - Version: 11.2.0.4

Viewed 100+ times

You Asked

In a RAC environment since we are using more than one nodes for a database, will there be more read/write congestion than in a standalone ASM database? If yes, is there any solution to minimise that congestion.

and we said...

That a big topic :-)

The docs cover some best practices in terms of running a successful RAC cluster

https://docs.oracle.com/en/database/oracle/oracle-database/19/racad/design-and-deployment-techniques.html#GUID-6F08D689-193E-49A3-8166-E6F5928561F8

and if you really want to dig into the internals, Anil Nair has a nice presentation here

https://www.doag.org/formes/pubfiles/10893399/2018-DB-Anil_Nair-Oracle_RAC_Performance_Internals-Praesentation.pdf

You can think of RAC as a like a music amplifier.

Amplifiers, given good music, will produce louder, good music with better bass and better sound.
Amplifiers, given white noise , will produce louder, more annoying more ear hurting noise.

RAC is sort of like an amplifier. Give it an application that can scale and it will scale great. Give it an application that couldn't scale on a single machine (eg: no bind variables, hard parse city) and it still won't scale on many nodes

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database