Re: load balancing on a multi-processorsysstem

depending on version and licensing you can set parallel option

parallel_max_servers derived from cpu_count parallel_automatic_tuning <true,false
and you can even set the parallel exec at table level

keep in mind that you apps can handle that kind of parallelism otherwise you may run the deadlock situations

--
Posted via http://dbforums.com