Re: Finding out historical cpu-usage

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 11 Oct 2011 14:00:55 +0200
Message-ID: <CAJ2-Qb_PcPFVwNuDb=EFZYXSaGAYEA7v48iLLgVuEpLdwrWzhA_at_mail.gmail.com>



Hi
I use dba_hist_sysmetric_summary or dba_hist_sysstat

in case of sysmetric you can look for several cpu metrics such as Host *CPU*Utilization, cpu usage per sec, db time cpu ratio

sysstat look for CPU system statistics

Thanks

On Tue, Oct 11, 2011 at 11:32 AM, Jan-Hendrik Boll < jan.hendrik.boll_at_googlemail.com> wrote:

> Hi Lister's,
> i am currently investigating which session consume the most cpu-time per
> instance.
> In order to do so i am using the view dba_hist_active_sess_history
>
> Tracking down the time spent waiting for typical wait-events like 'log file
> sync' seems easy as it is the sum of time_wait for that event.
>
> But how can i find out the CPU-Time?
> Is CPU time the sum of wait_time in which the session_state equals 'ON CPU'
> ?
>
> Any clarification about the meaning of these two columns would be greatly
> appreciated.
>
> Kind regards,
> Jan-Hendrik Boll
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 11 2011 - 07:00:55 CDT

Original text of this message