Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
From: mohamed houri <mohamed.houri_at_gmail.com>
Date: Tue, 13 Nov 2012 16:07:12 +0100
Message-ID: <CAJu8R6iev47E-+=U_kAPYVoeR46L3wU4UXX5mOfwMJyL5=h9EA_at_mail.gmail.com>
When you multiply the number of CPU by the duration of the Statspack report you will get the *total CPU time available*. This is why I beleive that you have to compare your sql cpu time with that total CPU available time and not with the DB CPU which represent the amount of DB time spent on the CPU. Isn't it?
Date: Tue, 13 Nov 2012 16:07:12 +0100
Message-ID: <CAJu8R6iev47E-+=U_kAPYVoeR46L3wU4UXX5mOfwMJyL5=h9EA_at_mail.gmail.com>
When you multiply the number of CPU by the duration of the Statspack report you will get the *total CPU time available*. This is why I beleive that you have to compare your sql cpu time with that total CPU available time and not with the DB CPU which represent the amount of DB time spent on the CPU. Isn't it?
Best Regards
Mohamed Houri
www.hourim.wordpress.com
2012/11/13 Ls Cheng <exriscer_at_gmail.com>
> Hi
> unfortunately thse are SELECT statements, not DML so I dont think the
> trigger applies in this case
>
> Thank you
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Bien Respectueusement Mohamed Houri -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 13 2012 - 16:07:12 CET