Will these activity cause performance degradation due to constant checking of the background process which server to connect?No not constantly, the checking will happen on just client request to connect time. And of course yes, because when listener has to do some kind of checking then it will require some time and server resource too, but overall it increase the connection performance.
Does this mean that host1,host2,host3,host4 can failover to anyone?Yes. Because what failover says :
yxes2013 wrote:Certainly doesn't sound like the same business you mention in [url https://forums.oracle.com/forums/thread.jspa?threadID=2503392&tstart=0]this thread
We have 1000+ POS machines connecting to a central database from 8am-6pm. All the machines is just doing "insert" 1 row.
What is the advantage of making its tns multi-threaded against dedicated? Assuming that I got lots of memory like 12Gb.
Thanks a lot,
Edited by: yxes2013 on 24.2.2013 19:40 **** addling OS or DB version :)
yxes2013 wrote:Step back a bit! You appear to be using two Connection Managers, one running on host1 and the other on host3. Your sessions will (on average) be distributed with half going to each CM. Then the CM on host 1 will make onward conentions to a database instance on host 2, while your CM on host3 is making onward connections to host4. this is actually quite a complex networking environment, it is not simple load balancing.
So I can make all the ports 1521 right? and not use 1630 or other ones.
jgarry wrote:Are you sure about memory savings? I have never been certain of any, and I can't see why there would be any. OK, a large chunk of PGA gets relocated to large pool, but I wouldn't have thought there would much reduction. The benefits I've see are in the system CPU usage, as Unix no longer has to context switch between zillions of processes.
MTS is for scaling, not performance. It starts becoming about performance when the number of concurrent connections uses so much more memory that memory management becomes the deciding factor. Use of hugepages also impacts that.
If you use MTS with transactions that are anything but very short you will run into problems with busy circuits. Since you say each will only insert a row, you may be ok, but still, dedicated tends to have better performance. MTS is for scaling memory limited situations.