Hi,

Is ora_p000_prodsid are there ?

Verify the parrallel_min_servers parameter .

Jagadish
-----Original Message-----
From: Jha C J
[mailto:oracledba-ezmlmshield-x93624329.[Email address protected]
Sent: Monday, April 30, 2007 6:54 AM
To: LazyDBA Discussion
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