List, For one of our business critical database, we have assigned 12 cpus with multi-thread(logical) of 24 cpus. What we have noticed that oracle is not using all the CPU avaibale, at least 4 (8 logical) cpus are not being utilized. We have checked from OS level using sar report to confirm the sam during business peak hours. Is there any limitation with oracle not to use many logical CPUs? Your time and advice is highly appreciated. -- Best Regards, Syed Jaffar Hussain OCP 8i & 9i DBA, Banque Saudi Fransi, Saudi Arabia http://jaffardba.blogspot.com/ ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l