Re: Basic question regarding parallelism and cpu usage

Harvinder,

Since nobody has replied to your question, here are a couple of thoughts for you:

• When you say you have 8 CPUs and Oracle is only using one, how many users do you have?
• Usually there are two aspects to multi-CPU usage by Oracle:
  1. Many users, Oracle automatically utilizes available CPUs for various processes.
  2. Single query across multiple CPUs. Now you are into parallel query tuning, and there are many good papers available on the Internet. You also have to examine your query to understand if Oracle considers it elibible for parallel processing.

Hope this helps,
Dennis Williams

--
http://www.freelists.org/webpage/oracle-l