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

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

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