| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cpu costing while in development
Ryan
I think a lot depends on how much you judge the risk to be. Cary has some ideas in his book (Optimizing Oracle Performance) for taking the logical I/O's and trying to extrapolate them to the upper limit of LIOs for your server. Also, I think www.oraperf.com has some capacity planning ideas that might be worth looking into.
If the full user load will be applied immediately on rollout, then it is worth going to more effort to verify your application and configuration since you don't get much opportunity to make changes. What we've done in the past is recruit the users to get on the system in a test mode at a certain time and perform tasks simliar to what they will be doing in production. In the worst case when the new system can't handle the load, if the users didn't choose to participate then they usually aren't as angry over problems as if the computer people performed some "magic" testing, with a simulator, for example.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net
Sent: Monday, May 03, 2004 9:38 AM
To: oracle-l_at_freelists.org
Subject: cpu costing while in development
anyone have any strategy for using system stats before you go live to production? Before you know what times the user load will be highest?
I would like to atleast do some query tests in development before putting it in production?
do you gather system stats and then run a 'worst case' scenario test case and test it with that? What works for you?
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |