Re: Unexpected Parallel Query Execution

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 31 Jul 2004 10:49:26 +1000
Message-ID: <410aec6d$0$1901$afc38c87@news.optusnet.com.au>

"Matt" <mccmx_at_hotmail.com> wrote in message news:cfee5bcf.0407301636.2ac2757c_at_posting.google.com...
> > I see only two possibilities:
> > 1) DEGREE is set for some indexes
> > 2) the statement ALTER SESSION FORCE PARALLEL {DML|DDL|QUERY} is used
> >
>
> "Select distinct degree from dba_indexes" also returns 1.
>
> No-one (except me) is aware of parallel capabilities so I would be
> very surprised if anyone used this 'alter session force parallel'
> command or a parallel hint.
>
> I searched v$sqlarea while these parallel sessions were active and
> none of them included a PARALLEL keyword.
>
> Its a mystery...
>
> Matt

What's your setting for parallel_automatic_tuning in the init.ora??

Regards
HJR Received on Fri Jul 30 2004 - 19:49:26 CDT