Claudio,
I don't have much to add to the other replies you've received but ...
Do not bother running Oracle with only 256MB, my test PC (P4 3GHz) has
2GB. As one of the responder says - "memory is cheap" get some!
As for Shared vs Dedicated - as you are running 200 connections Shared
seems the obvious solution but you should be able to tell from the
process list. If you have a large number of Oracle processes (in
dedicated mode) each one will need a chunk of memory which you have
little of so will end up using the paging file - poor performance
results. In Shared mode you will see a number of Shared Server
processes and a number of Dispatcher processes (depending on your
configuration) and the load at the time. I have run both Shared and
Dedicated, but on Linux (RHEL AS3) and have no experience of
configuration on Windows.
Under Shared server there are memory considerations with the size of the
Large Pool and performance can be improved by increasing the size of the
buffer cache, but all this requires physical memory. I think you get
the point - the more memory the better!
HTH,
John
-----Original Message-----
From: Claudio Alonso -Oracle DBA
[mailto:oracledba-ezmlmshield-x75661469.[Email address protected]
Sent: 30 January 2007 13:53
To: LazyDBA Discussion
Subject: Shared or dedicated server?
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
**********************************************************************
APAK Group plc, Registered in England No. 1451033. Registered office APAK House, Badminton Court, Station Road, Yate, Bristol, BS37 5HZ.
The information contained in this message or any of its attachments may
be privileged and confidential and intended for the exclusive use of the
addressee. The views expressed may not be APAK policy but the personal
views of the originator. If you have received this message in error, please
advise the sender immediately by reply e-mail and delete this message and
any attachments without retaining a copy. This footnote also confirms that
this email message has been swept for the presence of known computer
viruses before being sent.
**********************************************************************
Oracle LazyDBA home page