Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Database Load & Server Specs
Hi all,
I have three questions, would appreciate if any of you can help me on that,
its important because I need these answers to support my claim of our server
being over loaded.
First is; is there query to find out the number of transactions at any time? V$transaction tells about the time the query has been running for, but how many transactions are running at peak time? Does the number of transaction have any bearing on what the server specification should be like?
Second; what should be the specifications of a server, based on the size of
the database or load? Are there any norms for this, or a matrix, which would
help me see the specs based on load, or if any of you can share your
experience?
(Our environment is OLTP, round the clock, 24x7, size of the physical
database is 15GB, and growing and the actual dump size is less though,
around 5GB. We are using only one server, single processor 933MHz, 896MB
ram, and 2 SCSI hard drives. Our application is module based, and since we
made part of our last module online, the load has increased tremendously as
it involves constant entry, reporting, and on screen viewing. I mean on
WinNT, the CPU usage touches (for a few seconds thankfully) 100% every
minute or two, which does make the system go a little slow every now and
then.
If the configuration seems ok, which parameters can I consider
revising/increasing to enhance performance?)
Third; since our is a critical hospital application, 24x7 environment, running on one server, with periodic Tape backups and one standby database, as our means to fall back on. Does that sound Ok? Or do we need a couple of servers, same specs, go for operating system clustering, with a storage unit housing a few Hard disks?
I know it's a very long query, but would really appreciate if I can have some guidelines.
Thanks and regards,
Hussain
DBA
SKMCH&RC
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: hussain_at_skm.org.pk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Jan 22 2003 - 08:09:03 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |