Re: Max Connections on Oracle Server??

Dianne Siebold <dsiebold_at_wrightstrat.com> wrote in article <01bcbf03$bce4f560$7193d4cc_at_patch>...
> We are creating a c/s app using VB5 connecting to Oracle via RDO. The
> server will be a high-powered Unix box (I don't have the specs at this
> time). When we initially developed our app (against Access), we opened a
> connection each time we issued a query and then closed it. This was done
> to avoid having 75-100 apps with open connections on the server.
>
> Now we are moving against Oracle, and the connection time takes a while,
 so
> we are looking at having the app connect once and then issuing queries.
 Is
> there going to be a performance issue with this many open (75-100)
> connections on the server? Does anyone have any experience with "too
 many"
> users and how many that might be?
>
> Thanks in advance for your assistance.
>

If you have enough memory, lotsa connections MAY not be a problem.

To save memory, try using MTS(Multi-Threaded server) which combines several connections into a few 'backend' processes. W/O MTS, Oracle has 1 backend process/connection. With MTS is many connections/few backend processes.

-- 
==========================================================================
Scott Overby                  E-mail  scott.overby_at_sdsdata.com
Sr. Systems Analyst		Phone   (414) 459-7999
INPire Insurance Solutions    FAX     (414) 459-9123
615 Penn Ave.                   
Sheboygan, WI 53082

     _/_/_/  _/_/   _/  _/_/_/        \  |  /
       _/   _/ _/  _/  _/              \ | /
      _/   _/  _/ _/  _/_/_/  _/_/_/_/  _/  _/_/_/  _/_/_
     _/   _/   _/_/      _/  _/    _/  _/  _/  _/  _/  _/
  _/_/_/ _/    _/   _/_/_/  _/_/_/_/  _/  _/      _/_/_/
                          _/
                         _/
===========================================================================