Re: RAC and load balancing

From: Don Granaman <granaman_at_cox.net>
Date: Fri, 14 May 2004 02:05:37 -0400
Message-ID: <01e501c439ee$e42fe400$6401a8c0@dilbert>

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_at_cox.net> To: <oracle-l_at_freelists.org> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 14 2004 - 01:04:47 CDT