Re: Re: DB CPU and DB Time

From: Hansraj Sao <hansrajsao_at_gmail.com>
Date: Wed, 18 Feb 2015 11:15:19 -0500
Message-ID: <CADq6Cc7Ka-3KmNdsKjK8R3xBx5MaD5YZyE5vKHpMCXNyABMEkg_at_mail.gmail.com>

This seems to be some bug during load profile calculation in AWR report. To verify check DB Time * 60 at top section of AWR and check DB CPU at "Top 10 Foreground Events by Total Wait Time" section or "Wait Classes by Total Wait Time" . that will give correct picture.

Thanks
Hansraj

On Wed, Feb 18, 2015 at 1:48 AM, xiangdongzou <xiangdongzou_at_gmail.com> wrote:

>
>
>
> 2015-02-18
> ------------------------------
> *I AM AN ORACLE FANS!*
> *Skype:Frank.oracle*
> *Email:xiangdongzou_at_gmail.com <Email%3Axiangdongzou_at_gmail.com>*
> *Name:东东堂*
> ------------------------------
> *发件人：*Hansraj Sao <hansrajsao_at_gmail.com>
> *发送时间：*2015-02-18 03:07
> *主题：*Re: DB CPU and DB Time
> *收件人：*"mark.brinsmead"<mark.brinsmead_at_gmail.com>
> *抄送：*"xiangdongzou"<xiangdongzou_at_gmail.com>,"oracle-l_at_freelists.org"<
> oracle-l_at_freelists.org>
>
> Can you tell values BUSY_TIME, IDLE_TIME and NUM_CPUS from operating
> system statistics section of AWR.
>
> On Tue, Feb 17, 2015 at 3:14 AM, MARK BRINSMEAD <mark.brinsmead_at_gmail.com>
> wrote:
>
>> Perhaps you have more than one CPU?
>>
>> On Tue, Feb 17, 2015 at 2:11 AM, xiangdongzou <xiangdongzou_at_gmail.com>
>> wrote:
>>
>>> Can anyone tell me why my awr display that DB CPU is greater than DB
>>> Time?
>>>
>>>
>>>
>>>
>>>
>>>
>>> 2015-02-17
>>> ------------------------------
>>> *I AM AN ORACLE FANS!*
>>> *Skype:Frank.oracle*
>>> *Email:xiangdongzou_at_gmail.com <Email%3Axiangdongzou_at_gmail.com>*
>>> *Name:东东堂*
>>>
>>
>>
>
>
> --
> Thanks,
> Hansraj
>

-- 
Thanks,
Hansraj




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

Received on Wed Feb 18 2015 - 17:15:19 CET