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