Re: Dedicated Vs. Shared Server Mode

"Ryan" <rgaffuri_at_cox.net> wrote in message news:<82xX8.62383$%%2.2573508_at_news2.east.cox.net>...
> Someone I work with told me that you should not even consider shared server
> until you have atleast 200 concurrent users.
>
> Is this a good rule of thumb?
>

It depends on how much system resource you have. Each oracle server process takes up dozens of MB of physical memory (on UNIX). So you can easily figure out how many server processes you can have before they start getting paged in and out. On Windows oracle servers are threads not processes so the impact on memory is not as bad. For typical Web applicatins where most requests are short transactions or queries you won't see much difference whether you use dedicated or shared servers. But if you process long queries and transactions then dedicated servers will be more appropriate.

>
> "D.Y." <dyou98_at_aol.com> wrote in message
> news:f369a0eb.0207112027.7cf42728_at_posting.google.com...
> > chrisforbis_at_yahoo.com (Chris Forbis) wrote in message
> news:<f2dc430d.0207110718.7e242ed_at_posting.google.com>...
> > > That is one of those fun questions you can get all sorts of answers
> > > for. But dedicated is always faster if setup correctly. But
> > > dedicated needs more resources. Now it looks like if all that will
> > > use it is WebSphere, well that is not that many connections. So
> > > dedicated seems the best with the information you provided.
> > >
> > If the number of concurrent sessions is relatively small dedicated
> > servers will work just fine.
> >
> > > peter.peltonen_at_iki.fi wrote in message
> news:<agjk54$e5o$1_at_oravannahka.helsinki.fi>...
> > > > I am creating an initial db with the Oracle Network Configuration
> > > > Assistant.
> > > >
> > > > I am now wondering if I should install the db in Dedicated or Shared
> > > > Server Mode:
> > > >
> >
> > A dedicated server only serves one session. A shared server can serve many
> > sessions. If there are going to be a large number of concurrent sessions,
> use
> > MTS.
> >
> > > > The DB is to be serving a WebLogic J2EE Application Server which is
> > > > talking to it via JDBC. This will be the only client that will be
> issuing
> > > > queries to the db.
> > > >
> > > > So, in which mode should I install the db in this case? If in Shared
> Mode,
> > > > should I use Connection Pooling and if so, what would be the values
> one
> > > > might suggest to use with it?
> > > >
> >
> > Connection pooling really won't give you more active connections. Shared
> > servers will. But since WebLogic allows you to easily create connection
> pools
> > you might as well use it, so that you don't have to keep opening and
> closing
> > connections. Just pay attention to some minor details. A common mistake I
> have
> > seen is not closing the ResultSet before releasing a connection. Then
> you'll
> > quickly reach the maximum number of cursors.
> >
> > > > Regards,
> > > > Peter
Received on Fri Jul 12 2002 - 13:57:42 CDT