Detailed discussion is available in Millsap/Holt Optimizing Oracle Performance, pages 141-149 and, perhaps of particular interest to Raj in light of Mladen's comment, pages 161-165. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com <http://www.hotsos.com/> Nullius in verba Visit www.hotsos.com <http://www.hotsos.com/> for curriculum and schedule details... _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gogala, Mladen Sent: Tuesday, October 04, 2005 12:16 PM To: 'rjamya@xxxxxxxxx'; VIVEK_SHARMA@xxxxxxxxxxx Cc: Oracle-L Subject: RE: CPUs NOT getting consumed ? CPU is measured only after the SQL stops executing. CPU consumption is NOT measured in real time. CPU consumption is meaningful only for the statements that are not being actively executed. -- Mladen Gogala Ext. 121 _____ From: rjamya [mailto:rjamya@xxxxxxxxx] Sent: Tuesday, October 04, 2005 1:05 PM To: VIVEK_SHARMA@xxxxxxxxxxx Cc: Oracle-L Subject: Re: CPUs NOT getting consumed ? I don't suppose your app will be continuously using CPU. If it is, you have a beast of a problem to handle. Could it be that your processi is doing I/O and hence not using CPU? Another minor question, why are you worried that is isn't using the CPU. Raj