Re: Is there an alternative to "alter session disable parallel query"?

On 6/1/06, Radoulov, Dimitre <cichomitiko_at_gmail.com> wrote:
>
> > Oracle 10.2.0.1/Sun Solaris 8
> >
> > We have tried a number of things like the no_parallel hints, parallel
> > degree 0, outlines, rule hints, but they all end up using parallel query
> > for a particular table (with parallel specified in the DDL). As we are
> > trying to tune one specific query and not all queries against this
> > table, we are not yet interested in changing the system-wide parallel
> > parameters, nor the DDL. Are there any other tricks we can look at other
> > than explicitly altering the session?
> May be your syntax is wrong.
>
>
>
>
> Regards
> Dimitre
>

and don't forget no_parallel_index as well if appropriate

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l