Re: Grid Control and one database cpu usage
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: harel.safra@xxxxxxxxx
- Date: Thu, 2 Sep 2010 16:27:48 +0100
That'll give the host cpu and not the db CPU
I suspect that the OP is after something along the lines of
select target_name,rollup_timestamp,column_label,average,maximum
from mgmt$metric_daily
where target_type = 'oracle_database'
and metric_column = 'avg_user_cpu_time_pct'
order by 1,2;
(or substitute mgnt$metric_hourly)
performing the obvious restriction to get a specific target this gives
28-MAY-10 00:00 Average Instance CPU
(%) 1.42916795069337442218798151001540832049 98.73
29-MAY-10 00:00 Average Instance CPU (%) 1.21625 77.8
30-MAY-10 00:00 Average Instance CPU
(%) 1.15764419735927727588603196664350243224 93.01
31-MAY-10 00:00 Average Instance CPU
(%) 0.9163863794301598332175121612230715774844 52.92
01-JUN-10 00:00 Average Instance CPU
(%) 1.0708692628650904033379694019471488178 92.59
02-JUN-10 00:00 Average Instance CPU
(%) 1.15981944444444444444444444444444444444 87.33
03-JUN-10 00:00 Average Instance CPU
(%) 1.21306462821403752605976372480889506602 74.16
I'm not actually sure that the available stats are that great for CPU
capacity planning by database - the data is aggregated too much.
On Thu, Sep 2, 2010 at 3:59 PM, Harel Safra <harel.safra@xxxxxxxxx> wrote:
> Look at the performance metrics of the database's host.
>
> Harel Safra
> (Sent from my phone, excuse the terseness)
>
> ב-2 בספט 2010, בשעה 14:51, "J. Dex" <cemail_219@xxxxxxxxxxx> כתב/ה:
>
> Using Grid Control, is it possible to get a report on a particular
> databases cpu usage during a certain period of time? How can that be
> done? I can see how it can be done from the server level but not for just
> one database.
>
> Thanks.
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
