Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

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

.

Relevant Pages

  • Re: optimizer and MTS
    ... The answer is NO. MTS is just a connection mechanism. ... Oracle refers to this feature as Shared Server now. ... With version 10g Oracle provides a utility for combining trace files ... increase the shared pool size to support the Shared Server processing. ...
    (comp.databases.oracle.server)
  • Re: Oracle Shared Mode for Asp.net
    ... we have several Asp.Net sites that consume the oracle ... sometimes there are 200 ~ 300 connections to Oracle. ... Is there a good reason why not to use Shared mode? ... shared server is unsuited for long running queries ...
    (comp.databases.oracle.server)
  • Re: optimizer and MTS
    ... The answer is NO. MTS is just a connection mechanism. ... Oracle refers to this feature as Shared Server now. ... Yes it does reduce the memory requirements. ...
    (comp.databases.oracle.server)