In an earlier version, I could only support 258 users using dedicated
connections on a server with 4 Gb of memory. We switched to MTS and now
routinely support 550 - 600 concurrent logins.
>>> "Holley Craig W. "
<oracledba-ezmlmshield-x72338136.[Email address protected] 1/30/2007
14:46:08 >>>
Claudio,
Oracle says (and my experience has been) that you don't want to
touch shared server unless you have a minimum of 300, generally over
1000 users. They have continually revised their advice upwards since
MTS/shared servers came out. Some of it does depend on the size of the
box, but I would not switch with less than 300 users, esp because of the
admin pain.
Craig
-----Original Message-----
From: Claudio Alonso -Oracle DBA
[mailto:oracledba-ezmlmshield-x38907702.[Email address protected]
Sent: Tuesday, January 30, 2007 2:37 PM
To: LazyDBA Discussion
Subject: Re: Shared or dedicated server?
Thanks to all who answered.
I get the main point: Discard this "grand-mother's computer" and get a
useful one.
I'm trying to get at least a 2 processor Xeon computer with 2 Gb RAM
for the
test environment and with 3 or 4 Gb for the production environment.
Up to there the opinions are clear and uniform.
On the other side, the shared vs dedicated thing has different opinions
(in
some of them I'm not sure if they are related to the poor equipment or
to the
kind of DB usage).
So I would like to re-ask your opinion supposing I get a computer with
that
new configuration for the test environment where the load would be of
about 10
users (I imagine between 80 and 100 processes).
I believe (may be wrong) that there may be some threshold in the
equation of
processor type, available RAM, amount of processes, etc, where one mode
starts
to be preferrable over the other (prior to tuning tasks). But this is
surely
not easy to tell beyond the experience -which I don't have much related
to
shared server mode.
Or is this a silly question?
Thanks again, and excuse me if this is not a proper question.
--Claudio
On Tue, 30 Jan 2007 10:53:13 -0300, Claudio Alonso -Oracle DBA wrote
> My client is a CRM application provider who usually installs their
application
> running with MS SQL Server. This time thy have a client that is
> willing to use Oracle, so I'd believe the performance should be much
> better than usual, but it's not the case. They did their best
> without an Oracle DBA, following external instructions from partners
> via email. The situation is kind of critical right now because the
> performance is not good and the project is in danger, so they asked
> for my help. So I'm starting to work with this database (Oracle
> running on a Windows environment) behind a CRM application with
> 20/30 users. The application usually opens 6 to 10 database
> connections for each user, so the amount of connections is normally
> about 200. Most of the time the application is processing
> transactions, but it's usual to see several times a day big reports
> being run by the supervisors. The performance is not good and the
> database is running on a 1 Gb RAM Pentium IV, configured to work
> with shared server processes (I believe it's a mistake though I
> don't have much experience in shared server mode so I might be
wrong)
> . Do you think that a database with these characteristics should be
> in a P-IV with 1 Gb of RAM running in shared server mode, or it
> would be better to change it to a dedicated server environment
> (and/or may be add some RAM). At the same time, what is the minimal
> ammount of RAM that you recommend for such a thing? My customer's
> customer is about to run a test on a separated server, so I'm
> building a new environment from scratch. The additional problem is
> that the test server has only 256 Mb of RAM (is it me, or are they
shooting
> to kill?).
> I hope you can give me some advice.
> Thanks in advance,
>
> --Claudio
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**************************************************************************************
The information contained in this email is privileged and confidential
information intended only for the use of the individual or entity named
as recipient. If the reader is not the intended recipient, please be
notified that any dissemination, distribution, or copy of this
communication is strictly prohibited. If you have received this
communication in error, please do not disclose this communication to any
other person. Please notify us immediately by telephone and return the
original to us at the address indicated above. Thank you
**************************************************************************************
The information contained in this email is privileged and confidential
information intended only for the use of the individual or entity named
as recipient. If the reader is not the intended recipient, please be
notified that any dissemination, distribution, or copy of this
communication is strictly prohibited. If you have received this
communication in error, please do not disclose this communication to any
other person. Please notify us immediately by telephone and return the
original to us at the address indicated above. Thank you
**************************************************************************************
The information contained in this email is privileged and confidential
information intended only for the use of the individual or entity named
as recipient. If the reader is not the intended recipient, please be
notified that any dissemination, distribution, or copy of this
communication is strictly prohibited. If you have received this
communication in error, please do not disclose this communication to any
other person. Please notify us immediately by telephone and return the
original to us at the address indicated above. Thank you
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page