Re: estimating overall CPU usage
- From: "zhu chao" <chao_ping@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2004 05:31:31 +0800
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@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
