Parallel queries

Parallel queries

 

  

Hi,

Our database spawns many parallel processes for select statement
queries, does anybody knows
how to bring it down and reduce on parallelism, our system gets too slow
due to this

Thanks

Chandra
________________________________________
This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.

If you have received this e-mail in error, please immediately notify the HealthPartners Support Center by telephone at (952) 967-6600. You will be reimbursed for reasonable costs incurred in notifying us.

Oracle LazyDBA home page