Re: Re: ora-600 question

Depending on the query, in dba_extents example there are hints only in one part of multi-part union all SQL, but nevertheless, good point :)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 29, 2003 1:04 AM

> If there're already hints like ordered and use_nl that tell Oracle how to
join,
> lack of statistics is less of a problem. In fact, you may need to use
those two
> hints in some queries against data dictionary even in pre-9i Oracle.
>
> Yong Huang
>
> --- Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> > Hi!
> >
> > Just for the record, in 9.2 some views such dba_extents use "ordered"
and
> > "use_nl" hints, which force usage of CBO.
> > If you don't have statistics calculated nor optimizer_dynamic_sampling
set
> > to at least 2, then you'll be using CBO with default statistics, which
> > usually are quite misleading.
> >
> > Tanel.
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Tuesday, October 28, 2003 11:09 PM
> >
> >
> > > The data dictionary should not have any statistics on them and thus
will
> > use
> > > rule as a "rule" so to speak.
> > >
> > > If you have run stats on the data dictionary you coul dbe running into
> > some
> > > odd bugs.
>
> __________________________________
> Do you Yahoo!?
> Exclusive Video Premiere - Britney Spears
> http://launch.yahoo.com/promos/britneyspears/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Yong Huang
> INET: yong321_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).