Re: Running utlrp creates too many Pnnn processes

> I'll pursue changing the cpu_count parameter because, as you said, 
> it will solve the majority of the problems.
> ...
> - Maureen

Why not precisely target the parameter you want to change instead of a 
"broad-spectrum" parameter? It's always a good idea to check dependent 
parameters when you change an unfamiliar one. Even though cpu_count seems 
to be modifiable with alter system (v$parameter.issys_modifiable is 
'IMMEDIATE'), you need to bounce the instance to see the difference. My 
test on 10gR2 shows that it not only changes parallel_max_servers, but 
db_cache_size as well (and my sga_target is 0), and therefore many other 
parameters associated with the latter (18 in my count), including 
_small_table_threshold. In 11g, it also changes _sqlmon_max_plan. These 
could have quite noticeable performance impact.

Yong Huang


      
--
http://www.freelists.org/webpage/oracle-l

Other related posts: