Re: Where in DBA_HIST_* is '%Total CPU' & '%Busy CPU'?

From: fmh <fmhabash_at_gmail.com>
Date: Fri, 9 Aug 2013 12:47:37 -0400
Message-ID: <CADpeV5yZLxU7yCUUw9fPKFrEmPE_-VtP9r_s1W5Yd0sjAf0a7g_at_mail.gmail.com>

I'll attempt to answer my own questions. Open to suggestions, though ... - DBA_HIST_SYS_TIME_MODEL: DB CPU & background cpu time - DBA_HIST_osstat: BUSY_TIME & IDLE_TIME

On Fri, Aug 9, 2013 at 12:38 PM, fmh <fmhabash_at_gmail.com> wrote:

> I see these in the awr report itself, but could not locate it in any of
> the dba_hist_* views. Could not find a view to compute it as well.
>
> I have an awr report showing a database with '%Busy CPU' of 2000%. This
> is calculated as (FgCpu+BgCpu)/HostBusyCpu. How can it be this much?
>
> --
>
> ----------------------------------------
> Thank you.
>
>

-- 

----------------------------------------
Thank you.


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 09 2013 - 18:47:37 CEST