Ever since we've moved to 10g, it seems that many queries are run in paralelle. When I do a 'top' on UNIX, I see about 12 processes like 'ora_p000_sid' to 'ora_p012_sid'.

This seems to reduce the performance of some statements. What parameters should I change to limit the number of paralelle processes for each querie.



Merci / Thanks
Yves Leonard,
Chef de Projet / Project Leader,
DDS / SDD,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]



Oracle LazyDBA home page