Question: How many LMS processes for Oracle 9i Rac? Can you check if you have increased the CPU in the machine during the upgrade. Also please let me know if you have changed any underscore parameter. Do you have some formula for calculate LMS processes and Num of CPU ?? Let say 2 CPU for 1 LMS process ??   Answer: This can go dynamically as and when required and the # of startup of lms is also controlled by _lm_lms,_lm_max_lms _lm_min_lms , later 2 seems to be for dynamic control of this numbers. These parameters should not be set manually. Also the no. of lms process should be one less than the number of CPU on the node.