Re: Finding out historical cpu-usage
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: jan.hendrik.boll@xxxxxxxxxxxxxx
- Date: Tue, 11 Oct 2011 14:00:55 +0200
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@xxxxxxxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
