Tag Info

Hot answers tagged


Which Database Version do you have? From Oracle 11g onward you should be using the SCAN listener. The SCAN listener knows where the database is located in the RAC and how much load is on that node. Further more you should define services for long ops and short ops for better load balancing.


This (old) Oracle document 67137.1 Load Balancing and DESCRIPTION_LISTs1 says the following about the effects of multiple DESCRIPTION elements: When SQL*Net reads a TNS alias with a DESCRIPTION_LIST, it flips a coin to select which description to use to connect. This randomization is what provides us with our Load Balancing feature. It further ...

Only top voted, non community-wiki answers of a minimum length are eligible