Oracle does not control thread distribution across multiple CPUs, this is handled by NT.

If you want to use multiple CPUs, you have to implement parallel execution. Using parallel execution multiple processes work together simultaneously on a single statement over multiple CPU's.

See

http://download-west.oracle.com/docs...2paral.htm#365

for more info

Regards