With this you will not be able to change this for each query unless you use NOPARALLEL / PARALLEL hints to remove / use parallel operations for each of your queries.

At the database level you can set parallel_max_servers to 0, this in effect turns of parallel operations due to not having enough parallel server processes available.

At a session level you can use alter session disable parallel query / dml.

Cheers

Keith


-----Original Message-----
From: Yves
[mailto:oracledba-ezmlmshield-x82176730.[Email address protected]
Sent: Wednesday, 31 August 2005 3:24 AM
To: LazyDBA Discussion
Subject: Parallelle processes....


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
Tiliphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page