How to setup parallel in an SMP Server
                                                 Last update (2010-08-05 13:31:36)
                                                                                                                   Date added (2008-05-30 14:44:43)

Summary
The parallel query option of Oracle can really speed up things when you perform full table scans or full index scans(in case you have multiple cpus).

For example if you have a Unix server with 16CPUs then you must take advantage of the multiple cpus and setup parallel processing. A good setup is aproximately, for minimum parallel slaves 16/4=4 and for maximum 16*4=64.

Set the following parameters in the initialization file.
parallel_min_servers=4
parallel_max_servers=64
parallel_min_percent=0
recovery_parallelism=0
fast_start_parallel_rollback=LOW
parallel_automatic_tuning=FALSE
parallel_execution_message_size=16384 
Other links
Monitor parallel sessions
Restrict RAC parallel operations to a limited number of instance
PX Deq wait events
Reviews
Categories
Filters
Search