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

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


Friday, November 17, 2006, 2:39:29 AM, Garrett, Philip wrote:

GPMC> Chris Drake wrote:
I'm expanding, and adding extra web servers to handle my load. My
Apache/mod_perl environment maintains a new connection for each
process, and these processes seem to chew up a lot of server
resources.

What is the normal acceptable way to maintain large numbers of
simultaneous connections?

I have enabled "shared server" support in my database, but I suspect
it's not being utilized, since I only get a few hundred connections
before hitting the "too many connections" error.

Am I supposed to be passing a switch in with my initical "connection"
requests to request a shared (instead of dedicated) connection maybe
?

GPMC> You'll want to read the Oracle Net Services Administrator's Guide.
GPMC> http://www.lc.leidenuniv.nl/awcourse/oracle/network.920/a96580/mts.htm#4
GPMC> 53189

From a higher-level architectural viewpoint, you could use some load
GPMC> balancing. Look into SQLRelay. It provides out-of-process connection
GPMC> pooling that can work for mod_perl servers.
GPMC> http://sqlrelay.sourceforge.net/

GPMC> Regards,
GPMC> Philip



Friday, November 17, 2006, 2:30:08 AM, Robert Hicks wrote:

RH> Chris Drake wrote:
Hi All,

Is there a way to specify that a connection should use the Oracle
"shared server" feature? I'm only getting a max of a hundred or so
connections, each kicking off it's own oracle process to handle it:
unless I'm mistaken, a new process means it's *not* a shared
connection?

Kind Regards,
Chris Drake


RH> If you don't get your answer here the dbi.perl ng would be the place to
RH> go for an answer.

RH> If you can't get there let me know and I can post for you and post back
RH> here the answer(s).

RH> Robert


RH> ---------------------------------------------------------------------
RH> Web Archive:
RH> http://www.mail-archive.com/cgiapp@xxxxxxxxxxxxxxxxx/
RH> http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
RH> To unsubscribe, e-mail: cgiapp-unsubscribe@xxxxxxxxxxxxxxxxx
RH> For additional commands, e-mail: cgiapp-help@xxxxxxxxxxxxxxxxx



.

Relevant Pages

  • 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: Limitation of Oracle XE
    ... The answer, in typical Oracle fashion, is 'It depends'. ... connections. ... With the APEX/HTMLDB using Shared Server, ... limit of concurrent network connections on some version of Windows to ...
    (comp.databases.oracle.server)
  • ASP engine siezes
    ... We run a shared server with roughly 200 domains, ... having problems with the ASP engine siezing and not accepting anymore ... connections 'Too many connections'. ...
    (microsoft.public.inetserver.iis)
  • Re: Shared Server configuration on a datawarehouse
    ... using shared servers instead of dedicated servers because of the amount of ... He then went on to say the max connections we've had ... I don't think 40 concurrent connections is that many and I would not set up Shared Server for it. ...
    (comp.databases.oracle.server)
  • ASP engine siezes
    ... the log file to the group. ... >We run a shared server with roughly 200 domains, ... >connections 'Too many connections'. ... >after IIS being reset or 10 days, ...
    (microsoft.public.inetserver.iis)