Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: see higher CPU usage after increase SGA

Re: see higher CPU usage after increase SGA

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 10 Jun 2004 07:46:09 -0700
Message-Id: <1086878769.2159.5.camel@poirot>


On Wed, 2004-06-09 at 23:40, zhu chao wrote:
> 1. Sorry I did not measure the application response time. As there are too
> many connections to the database.

That is the one thing you should measure.

> I *GUESS* there won't be noticable speedup in the program, as database
> layer is just maybe 30-50% of total application response time, and the
> application WAS pretty fast, most of them finished in 0.001-0.05Second.

> 2. What is most important to me is: Scalability, that is, to support more
> user, more transactions. As this is difficult to measure how much more
> business we can support, we use System Resource Usage percent to estimate
> it. So sorry, the answer to your second question is: Ratio. Do you have
> some suggestion about measure capacity other than the resource utilization
> ratio? Thanks.

You don't quite see the flaw in that.

Scalability from an application perspective is just as you stated it, the measure of how many business transactions the App and HW can support.

Using a ratio will not provide that measure. Ratios don't provide an indicator of how many transactions the system can handle, and don't provide any clues as to how to improve scalability.

Jared



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Jun 10 2004 - 09:32:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US