RE: HW evaluation for Oracle DB

Before you can figure out what hardware resources might improve your throughput and reduce your response time, you need to figure out what is consuming time currently.  

If issues of concurrency are the root of your problems, it is probable that design revisions would be more important than hardware upgrades.  

But tracing to discover the predominant wait events in your most important queries that are currently considered problems will at least give you an idea of what they are waiting for from the database engine (which includes actually waits, which may be concurrency issues such as waiting for a latch as well as service times such as lios and pios). Remember that, for example, if only 5 seconds of a query’s time is spent on i/o, then you could only improve the query time by 5 seconds with infinity fast i/o, so if you’re looking for 30 seconds of improvement you must look for something else.  

You wrote “lately” so also check to see if something new is being done at awkward times, as opposed to “organic growth” which folks sometimes call just doing what you’ve done for quite a while but now at a higher rate.  

Good luck,  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Ramírez Reyes
Sent: Monday, May 09, 2011 2:48 PM
To: oracle-l_at_freelists.org
Subject: HW evaluation for Oracle DB  

Hello guys:  

I need to make an evaluation of my hardware in order to see if we need to get something "extra"; I know that more physical memory and number of cpu's are always the ideal, but what parameters or statistics can I evaluate in a number or scale in order to know how my HW is working and how it could work?  

This is something important for me as I have been having some problems of performance lately so, which parameters would give me the image of this?  

Thanks to all  

David Ramírez Reyes
Profesión: Padre de Familia    

--
http://www.freelists.org/webpage/oracle-l