Re: estimating overall CPU usage

From: zhu chao <chao_ping_at_vip.163.com>
Date: Wed, 25 Feb 2004 05:31:31 +0800
Message-ID: <010801c3fb1d$92227160$1d42813d@chaos>

Hi,

Do a statspack report for all the instances at the same time(say, maybe 1 hour), and check the value of "CPU Used by this session".

Then you can simply compare the CPU usage of the individual instance.

regards
Zhu Chao.

Original Message ----- From: "Norris, Gregory T [ITS]" <gregory.t.norris_at_mail.sprint.com> To: <oracle-l_at_freelists.org> Sent: Wednesday, February 25, 2004 12:02 AM Subject: estimating overall CPU usage

> 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
> -----------------------------------------------------------------
>
>

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 - 15:29:15 CST