Re: dbms_stats using no_parallel_index internally
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- Date: Wed, 29 Mar 2006 14:55:36 -0800 (PST)
Sorry. Yes, we are on 10.2.0.2
I have opened a TAR for this since I found a similar
Bug 4960019.
Thanks,
Deepak
--- Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
> If you are on Oracle 10
> AND
> you are adventurous
> you could set _optimizer_ignore_hints to true.
>
> Although I suppose Oracle has a reason for explxitly
> putting the
> no_parallel_index hint in the sql.
>
> Quoting Deepak Sharma
> <sharmakdeep_oracle@xxxxxxxxx>:
>
> > Even with specifying DEGREE=4, the dbms_stats
> > internally generates this Hint to use
> > no_parallel_index when processing the Indexes for
> the
> > table being analyzed. Any ways to force it to use
> > parallel or NOT TO USE no_parallel_index hint? I
> have
> > tried 'alter session enable parallel query', but
> still
> > produced the same.
> >
> > SELECT /*+ no_parallel_index(t,"DT_P_BIX")
> dbms_stats
> > cursor_sharing_exact use_weak_name_resl
> > dynamic_sampling(0) no_monitoring no_expand
> > index(t,"DT_P_BIX") */
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
