Re: Re: estimating overall CPU usage

From: Andy Rivenes <arivenes_at_llnl.gov>
Date: Tue, 24 Feb 2004 09:19:42 -0800
Message-Id: <5.1.0.14.2.20040224091221.0314a2e0@poptop.llnl.gov>

A close approximation of actual database CPU usage can be obtained using the statistic 'CPU used by this session' when sampled from v$sysstat on an interval basis over time. It's not perfect, and certainly not precise enough for response time optimization, but in general I have found that it gives a pretty good correlation to OS CPU time. I characterize this as workload utilization.

Andy Rivenes
arivenes_at_llnl.gov

At 11:29 AM 2/24/2004 -0500, ryan.gaffuri_at_cox.net wrote:
>shutdown 6 of 7 instances. run a test at peak load. calculate CPU usage.
>
>repeat for each instance. any other way to do this?
> >
> > From: Mladen Gogala <mladen_at_wangtrading.com>
> > Date: 2004/02/24 Tue AM 11:16:41 EST
> > To: oracle-l_at_freelists.org
> > Subject: Re: estimating overall CPU usage
> >
> > Well, it's the same thing as with the terrorist danger levels. I use
> colors from
> > gtop. The sentences read like like this: BBG database is yellow, PRDN
> is red
> > and CMPL is green. I have to change preferences in my gtop command to make
> > it compliant with the terrorist threats. I'm missing the orange level.
> >
> > On 02/24/2004 11:02:35 AM, "Norris, Gregory T [ITS]" wrote:
> > > I've got 7 databases which are sharing a Solaris server, and are
> scheduled to be split out onto separate boxes. As part of this process,
> I need to provide the capacity planning folks an estimate of the current
> CPU usage for each database. They apparently have an estimate for the
> total Oracle CPU usage already, and are looking for a per-DB
> percentages... something like "foo is using 20% of the total CPU, bar is
> using 15%, ...". Any suggestions for how to capture this information?
> > >
> > > Thanx!
> > >
> > > --
> > > My employers like me, but not enough to let me speak for them.
> > >
> > > Greg Norris
> > > Sprint LTD Database Administration
> > >

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 Tue Feb 24 2004 - 11:20:10 CST