Re: RAC and load balancing
- From: "Don Granaman" <granaman@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 14 May 2004 13:06:06 -0700
I'm a bit confused...[Nothin' new there..]
How many databases do you have on this cluster? I assume that you have an
ETL database with an instance on each node and (at least) one "production"
database with an instance on each node.
In general, load balancing via Oracle Net will simply pick an instance for
your session. It will not split any single session up between instances.
If you use load balancing to submit multiple scripts via multiple sessions,
then it *might* connect different sessions to different instances. However,
it may or may not result in a performance improvement. The answer is really
"It depends...".
-Don Granaman
(befuddled) OraSaurus
----- Original Message -----
From: <ryan.gaffuri@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, May 05, 2004 5:59 AM
Subject: RAC and load balancing
> We have a 4 node RAC cluster in production. We have an ETL instance and a
production instance on these 4 nodes. Our ETL instance is in noarchivelog
mode.
>
> Will I get a performance improvement if I run batch sql scripts from
seperate nodes or will the RAC load balancing take care of that for me?
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
