On Mon, May 19, 2008 at 6:18 AM, Fedock, John (KAM.RIC) <John.Fedock@xxxxxxxxxxxx> wrote: > Normal, homegrown queries started running in parallel. How can this happen > if the degree is 1 for all objects? Parallel hint? > Is there a way to set parallel_max_servers > 1 for streams, and not have PQ > option running on our application objects? You can use resource manager and set the max DOP to 1 for a given user class. -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l