Re: Finding out historical cpu-usage

From: Dave <david.best_at_gmail.com>
Date: Tue, 11 Oct 2011 13:06:31 -0400
Message-ID: <CAE+Q5FcBg5pcXkJKzpHu+4gN6vxgeCjSG2T7SoUxeobj=Q8yZw_at_mail.gmail.com>

I believe any %HIST% tables require the diagnostics pack? Correct me if i'm wrong.
If you just want raw CPU stats and don't have that pack, you can use sar as well. Depending on how your system is configured there should be a few days of history in /var/log/sa/saDD where DD is the day of the month.

sar -u -f /var/log/sa/sa10

The command above will show you cpu stats for the 10th day of the month.

tnx

On Tue, Oct 11, 2011 at 5: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 - 12:06:31 CDT