Claudio,
I don't normally respond, but I feel it is my duty as an Oracle DBA to
help you out.
Oracle on Windows is not the best solution, ask anyone at Oracle.
They'll recommend Linux for your OS.
But if your client insists on Windows, then you at least need to add
another 1 GB of RAM and you need Windows 2003 so you can take advantage
of the multithreading capabilities.
You also need to have at least 2 processors in order to allow for OLTP
and reporting on the same database.
I have 3 Oracle environments, but all 3 are on IBM UNIX (AIX) servers
and they all have dual proc's. We are running 32 bit AIX 5L and my test
server has 1.25 GB memory and it's around 37% used with no one on the
system.
My production system has 2 GB RAM and during the busy times, it's around
11% used only because I have around 15 constant users. You have quite a
few more users and more connections which require more system resources.
If your client doesn't believe you, you can install on your "test"
system and show them how a stress test affects such a small machine and
that might help you get more support in the hardware arena.
I hope this helps.
Thanks,
Brandy Jack
Database Management
[Email address protected]
ofc: (918) 615-7743
cell: (918) 527-4024
-----Original Message-----
From: Claudio Alonso -Oracle DBA
[mailto:oracledba-ezmlmshield-x75661469.[Email address protected]
Sent: Tuesday, January 30, 2007 7:53 AM
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
------------------------------------------------
The information in this e-mail is confidential and may be legally privileged. It is intended
solely for the addressee. Access to this e-mail by anyone else is unauthorized. If you are not
the intended recipient, be advised that you have received this e-mail in error and that any use,
dissemination, forwarding, printing or copying is strictly prohibited. If you receive this e-mail
in error, please immediately notify the sender via reply e-mail and delete this communication.
QuikTrip Corporation
Oracle LazyDBA home page