Re: DB CPU in Time Model

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 16 Aug 2011 14:19:24 +0100
Message-ID: <CABe10sadTWsyXiLo4=ZVq-psOJcV0N6HemhSxzjJ4m+5fGC5Og_at_mail.gmail.com>

Any sql statement that executes in parallel can consume more CPU than elapsed time - indeed that is rather the point.

On 16 Aug 2011 13:59, "Venkat Krish" <venkat.lear_at_gmail.com> wrote:

Thanks Niall.. I understand CPU seconds is depedent on # of cpus..

Usually if the cpus were consumed by SQLs (hash-joins,sorts, or I/Os), shouldn't the sql elapsed time also be approximately equal or more than DB CPU % (83% in this case).. I am lost on why sql elapsed time reports only 46% and there is nothing else (pl/sql elapsed time, parse time) that is significantly higher..

I guess , my question is.. can there be "DB CPU" slice thats not part of sql,pl/sql & parsing ?

Thanks
Venkat

On Tue, Aug 16, 2011 at 1:53 AM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:
>
> On a machi...

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

Received on Tue Aug 16 2011 - 08:19:24 CDT