RE: how to set parallel_max_servers without running PQ within out apps
- From: "Fedock, John \(KAM.RIC\)" <John.Fedock@xxxxxxxxxxxx>
- To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 May 2008 14:14:13 -0400
Are all set to 1 currently. I am working with Oracle on this now and will
post the solution when and if it occurs.
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]
Sent: Monday, May 19, 2008 1:40 PM
To: Fedock, John (KAM.RIC); oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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,'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
