Chris Drake wrote:
Hi Philip & Robert,
Thanks for those excellent references & help offers. Do you (or
anyone) know whether or not I should even be *using* a shared server,
and have you any idea about how many dedicated connections is "too
many" on a dual-3.8ghz Xeon Linux PC with 8gigs or RAM running
Oracle 10g?
The reason I ask is because this guy says "do not use shared servers"
http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm
... irritatingly, during install - Oracle gives no hints about what
numbers to put into "processes" and "sessions", so I've no idea if I
should be putting 200, 2000, 20000, or even if I should be changing
these at all...
Kind Regards,
Chris Drake
If a guy from Oracle says "Unless you have a real reason to use MTS --
don't." then you need to decide if you *really* need MTS, I guess.
I have never used an MTS.
Robert