How to determine number of proceses including parallel threads
Hi,
We are planning on migrating our data warehouse onto live environment.
Before we do this have been asked by hardware guys as to number of expected processes and parallel threads.
Basically load dimensions via OWB mappings which run as PL/SQL procedures on databases followed by the facts.
Generally how many opertaing system processes does 1 run of a pl/sql mapping (standard merges/inserts etc. nothing fancy) equate and what should we set the degree of parallelism to?
Many Thanks