multithreading / multicores
Hello,
I have questions about oracle multithreading capabilities on multicores/multi processors servers.
On a windows box, when looking at the task manager during database processes requiring a lot of processor resources, the oracle.exe process is high on resource but seem to run on only one processor. Can it run on more ?
If we use parallelized queries with hints in queries or by setting the correct initialisation parameters, does it change its way of working ? When it is used through options in some commands (impdp, utl_recomp ...) things are clearly faster even if I don't have the feeling that it uses more than one processor.
0