RE: how to set parallel_max_servers without running PQ within out apps

Jonathan,

You were right. I found one table that was used in the view that had INSTANCES set to default. After changing that to 1, we are running as we expect.

Thanks very much.

-----Original Message-----

From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk] Sent: Monday, May 19, 2008 1:40 PM
To: Fedock, John (KAM.RIC); oracle-l_at_freelists.org Subject: Re: how to set parallel_max_servers without running PQ within out apps

For the tables and indexes, did you set degree AND instances to 1 ? If you have degree = 1 and instances = default, it is possible (but I can't check it right now) that this will still allow Oracle to run a query with DOP as "degree x instances" - which in your case means parallel 2.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- From: "Fedock, John (KAM.RIC)" <John.Fedock_at_us.kline.com> To: <oracle-l_at_freelists.org> Sent: Monday, May 19, 2008 2:18 PM Subject: how to set parallel_max_servers without running PQ within out apps

For streams, we need to set parallel_max_servers to > 1.

I made sure all tables and indexes have parallel set to 1 and then set the above parameter.

Normal, homegrown queries started running in parallel. How can this happen if the degree is 1 for all objects?

Is there a way to set parallel_max_servers > 1 for streams, and not have PQ option running on our application objects?

This is a 2 node RAC, HP-UX system running 10.2.0.3.

TIA,'
--

http://www.freelists.org/webpage/oracle-l Received on Fri May 23 2008 - 09:29:41 CDT