Try the following

SELECT 'ALTER TABLE ' || TABLE_NAME || ' PARALLEL 1;' FROM USER_TABLES WHERE DEGREE > 1;

and then run the resultant ALTER TABLE statements.

If this "parallelism" has appeared without you explicitly running ALTER TABLE...PARALLEL 8 (for example) then it may, I think, be because the table was created with a parallel query in a CTAS (CREATE TABLE ... AS SELECT) statement - the parallelism remains on the table and any subsequent queries will run as parallel queries unless you run the above ALTER statement.



HTH
Cardy


-----Original Message-----
From: Yves
[mailto:oracledba-ezmlmshield-x82176730.[Email address protected]
Sent: 30 August 2005 18:24
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
Téléphone / 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




*****************************************************************************
This e-mail and its attachments are confidential and are intended for the above named recipient only. If this has come to you in error, please notify the sender immediately and delete this e-mail from your system. You must take no action based on this, nor must you copy or disclose it or any part of its contents to any person or organisation. Statements and opinions contained in this email may not necessarily represent those of Littlewoods Group Limited or its subsidiaries. Please note that e-mail communications may be monitored. The Registered Office of Littlewoods Group Limited and its subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB. Registered number of Littlewoods Group Limited is 5059352.
*****************************************************************************




This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com

Oracle LazyDBA home page