Check the value of the parallel_adaptive_multi_user parameter - it may be
good for you to switch this to true - this makes parallel jobs nicer to
other people on the system.

Check parallel_max_servers make its value less and you will restrict the
number of parallel processes which will be allowed to execute.

Additionally, are you absolutely sure that these parallel processes are
bringing your machine down?
Check to see if they are currently active - if they are asleep, then they
may not be affecting you much at all.
Just becuase there are lots of these processes, it doesn't means they are
behaving badly...

If there are big DW type queries going on, then it may be better to try to
get these scheduled to run out of hours or something like that. Reducing
parallism on these processes could make them run so slowly that they cannot
complete in their allotted time. Many things to consider.


----- Original Message -----
From: "Jha C J " <oracledba-ezmlmshield-x93624329.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, April 30, 2007 2:24 AM
Subject: 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.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page