10-09-07, 12:54 #1Registered User
- Join Date
- Oct 2007
- New Jersey
Unanswered: Multiple Listeners - Load Balancing
This is a two part question: 1. Can Oracle load balance TCP requests that arrive on one port over mulitple listeners . Or does Oracle provide additional software that can do this load balancing in a round-robin fashion to distribute the load amongst listeners.
2. Is there an advantage in using the "load balance" option with a listener, one listener listening on many ports as opposed to have many listeners each just listening on one port.
10-09-07, 13:19 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>1. Can Oracle load balance TCP requests that arrive on one port over mulitple listeners .
2. Is there an advantage in using the "load balance" option with a listener,
The Oracle listener ONLY is involved in establishing a NEW connection into the database. After the client connects to the database, the listener is out of the picture for the duration of that client session.
You are trying to solve a problem that only exists between your ears.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.