Where in DBA_HIST_* is '%Total CPU' & '%Busy CPU'?
From: fmh <fmhabash_at_gmail.com>
Date: Fri, 9 Aug 2013 12:38:17 -0400
Message-ID: <CADpeV5zpsupMhoPn+xtwjUK6KLJLZSMzkJ8f+LOa4zMZp8N=PA_at_mail.gmail.com>
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.
Date: Fri, 9 Aug 2013 12:38:17 -0400
Message-ID: <CADpeV5zpsupMhoPn+xtwjUK6KLJLZSMzkJ8f+LOa4zMZp8N=PA_at_mail.gmail.com>
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 09 2013 - 18:38:17 CEST