How to Enable Parallel Processing in a Datawarehouse Environment
Posted on 2003-11-26
I am using Oracle 9i Rel 2 Version 126.96.36.199 Enterprise Edition on Windows 2000 Advanced Server SP-4 installed on a 2X2GHZ Dell server supporting a new data warehouse.
We just switched over to Enterprise Edition and I'm trying to implement all of the DW features that I can. The word parallel is used in a lot of the functionality and I'm not sure that I understand all of it's application.
First question, is there a difference between parallel server and parallel processing?
Second question: These are the parameters I have and their settings. What do I have to change to implement parallel processing?
fast_start_parallel_rollback string LOW
log_parallelism integer 1
parallel_adaptive_multi_user boolean FALSE
parallel_automatic_tuning boolean FALSE
parallel_execution_message_size integer 2148
parallel_max_servers integer 5
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_server boolean FALSE
parallel_server_instances integer 1
parallel_threads_per_cpu integer 2
recovery_parallelism integer 0
Question: I have two Intel Xeon(512k cache) CPUs that actually appear, I guess because of the hyperthreading technology, as four processors. How many dbwriters and io-slaves should I configure. Does configuring these things automatically provide for parallel operations?