Database Administration (MOSC)

MOSC Banner

multithreading / multicores

edited May 6, 2010 9:03AM in Database Administration (MOSC) 3 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center