Re: Grid Control and one database cpu usage

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: