Everytime I tell my developers and analysts that 96 parallel servers is too many for one process of 6 separately executed sqlplus sessions, they just don't get it...or understand why they didn't get the number of parallel slaves they requested.... so I'm right there with you at least two, three times a month when some idiot attempts something like the above.. :P Kellyn Pedersen Multi-Platform DBA I-Behavior Inc. http://www.linkedin.com/in/kellynpedersen www.dbakevlar.blogspot.com "Go away before I replace you with a very small and efficient shell script..." --- On Thu, 1/14/10, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: From: Niall Litchfield <niall.litchfield@xxxxxxxxx> Subject: Re: new Patch Set Updates released To: kjped1313@xxxxxxxxx Cc: "development@xxxxxxxxxxxxxxxxx" <development@xxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, Brandon.Allen@xxxxxxxxxxx Date: Thursday, January 14, 2010, 3:15 AM On Wed, Jan 13, 2010 at 8:53 PM, Kellyn Pedersen <kjped1313@xxxxxxxxx> wrote: "Please discontinue using the feature until you upgrade to 11g!" Yes, this was a suggestion on a parallel query bug! Gotta love'm....:)) Oh I don't know Kellyn, "please just stop using parallelism" seems like a very good suggestion to me quite a lot of the time. I know it should please stop abusing parallel query, but sometimes I just think life would be better if it had never been invented, :( -- Niall Litchfield Oracle DBA http://www.orawin.info