Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
- From: mohamed houri <mohamed.houri@xxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Tue, 13 Nov 2012 16:07:12 +0100
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@xxxxxxxxx>
> Hi
> unfortunately thse are SELECT statements, not DML so I dont think the
> trigger applies in this case
>
> Thank you
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Bien Respectueusement
Mohamed Houri
--
//www.freelists.org/webpage/oracle-l
Other related posts:
