See pages 170-175 of the book Optimizing Oracle Performance if you have access to it. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Hotsos Symposium 2007 / March 4-8 / Dallas Visit www.hotsos.com for curriculum and schedule details... ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of amonte Sent: Wednesday, February 28, 2007 2:23 AM To: oracle-l@xxxxxxxxxxxxx Subject: cpu waits Hi all I was wondering what event does Oracle show when the process cannot get CPU cycles? TIA Alex