Re: Low CPU time, no Wait time but high elapsed time

From: LS Cheng <exriscer_at_gmail.com>
Date: Fri, 5 Aug 2011 09:17:16 +0200
Message-ID: <CAJ2-Qb9u9BkPnF_-yWJd4erZyS0QBoquY+RPTTEcFrJfq3UNrg_at_mail.gmail.com>

aha so this might mean the box was saturated and the LPAR couldnt get CPU fast enough?

Thanks

On Fri, Aug 5, 2011 at 8:07 AM, Toon Koppelaars <toon.koppelaars_at_rulegen.com
> wrote:

> That could explain it. I have had experiences where a trace-file of a slow
> session did not record any waittime with similar observation like yours.
> This was due to the fact that the 'slow session' was running inside a VM
> that did not get a lot of cpu-cycles allocated from the VM manager.
>
>
> On Fri, Aug 5, 2011 at 7:45 AM, LS Cheng <exriscer_at_gmail.com> wrote:
>
>> The catalog database runs in side an IBM P780 Logical Partition (LPAR)
>>
>>
>> Thanks
>>
>>
>>
>> On Fri, Aug 5, 2011 at 7:42 AM, Toon Koppelaars <
>> toon.koppelaars_at_rulegen.com> wrote:
>>
>>> Is this a virtualized environment?
>>>
>>>
>>>
>>> On Fri, Aug 5, 2011 at 7:38 AM, LS Cheng <exriscer_at_gmail.com> wrote:
>>>
>>>> Hi
>>>>
>>>> The other day while I was troubleshooting with 10046 some RMAN resync
>>>> issues with the catalog (was taking very long time) I noticed that insert
>>>> and update statements were taking extremely long time, one second per
>>>> execution more or less. The 10046 trace for the RMAN catalog database
>>>> session showed cpu time 10000 microseconds, no waits and elapsed around
>>>> 1200000 microseconds. This is 10.2.0.5 running on AIX.
>>>>
>>>> I did some research and couldnt find any good reason.
>>>>
>>>> Anyone come across with this sort of issue?
>>>>
>>>>
>>>> Thanks!
>>>>
>>>> --
>>>> LSC
>>>>
>>>>
>>>
>>>
>>> --
>>> Toon Koppelaars
>>> RuleGen BV
>>> Toon.Koppelaars_at_RuleGen.com
>>> www.RuleGen.com
>>> TheHelsinkiDeclaration.blogspot.com
>>>
>>> (co)Author: "Applied Mathematics for Database Professionals"
>>> www.rulegen.com/am4dp-backcover-text
>>>
>>>
>>
>
>
> --
> Toon Koppelaars
> RuleGen BV
> Toon.Koppelaars_at_RuleGen.com
> www.RuleGen.com
> TheHelsinkiDeclaration.blogspot.com
>
> (co)Author: "Applied Mathematics for Database Professionals"
> www.rulegen.com/am4dp-backcover-text
>
>

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

Received on Fri Aug 05 2011 - 02:17:16 CDT