Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.oracle.misc > #983

Doubts on Oracle RAC

Show all headers | View raw

Hi All,

Have few questions related to Oracle RAC, Please provide your inputs on these :

1. Based on what condition load balancing is happening between 3 Nodes?

2. Suppose 10 queries are executed from the application to the Database, how the load balancing happens in this scenario : 
a. The first 3 queries will go to Node1, the next 3 queries will go to Node2 and next 3 queries goes to Node3; and the last query goes to Node1 again?
b. The first 4 queries will go to Node1, the next 3 queries will go to Node2 and next 3 queries goes to Node3 ?
c. Any limit that can be set to a node on the No.Of queries executed, like 20 queries can be executed in Node1 and 30 queries on Node2 ?
d. Any other comments related to this scenario ?

3. I have 2 databases (Database1 and Database2) and i need to configure to configure the 3 Node RAC as below :
a. Node1 to take INSERT and DELETE statements alone from Database1, 
b. Node2 to take SELECT and UPDATE statements alone from Database1, and
c. Node3 to take all operations from Database2

i)   Is this possible, If yes how/where to configure these ?
ii)  How to identify that this scenario is working properly. Is there anything, other than AWR Reports to check this?
iii) RAC configuration files are placed in which server of this 3 Node RAC scenario ?
iv)  For Database1, data is stores in 3 places, Node1 server local storage, Node2 server local storage and Shared Storage (where Node1 and Node2 data syncs up). If yes, When does the data sync happens ?
v)   Any other comments ?

Thanks in Advance, 
Raja

Back to comp.databases.oracle.misc | Previous | Next — Next in thread | Find similar

Thread

Doubts on Oracle RAC raja <dextersunil@gmail.com> - 2016-10-14 02:56 -0700
  Re: Doubts on Oracle RAC "Michel Cadot" <micadot{at}altern{dot}org> - 2016-10-15 14:49 +0200

csiph-web