Re: Query gives incorrect results

Jim,

FYI: Oracle Support themselves tell you to analyze SYS schema on Oracle 9i ... although they say it with the caveat that "Performance might be affected for dd queries" .. With10i and RBO going away .. they are now recommending it more and more.

Hop onto metalink and see it for yourself. Although I would still stay away from analyzing SYS schema even in the latest version.

Anurag

"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:IqRDa.1142277$S_4.1174350_at_rwcrnsc53...
> This isn't MS SQL Server; a modicum of intelligence is assumed. Just cause
> it doesn't say in the package don't do it, doesn't mean you should. You
> might be able to log in as sys and manually add rows to system catalogs, but
> that isn't a smart thing either.
> Jim
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can figure
> it out.
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> news:bbnml4$bf2$1_at_dackel.pdb.sbs.de...
> > Jim Kennedy wrote:
> > > You could read the docs and find out that you should never analyze
> > > the sys schema.
> > > Jim
> > >
> > >
> > >> This last case seems related to cost-based optimizer. Try again after
> > >> EXECUTE sys.dbms_utility.analyze_schema ('SYS', method=>'COMPUTE');
> > >> or
> > >> EXECUTE sys.dbms_utility.analyze_database (method=>'COMPUTE');
> >
> > OTOH, the dbms_stats packe doesn't seem to have such a limitation.
> >
> > Lots of Greetings!
> > Volker
> > --
> > While it is a known fact that programmers
> > never make mistakes, it is still a good idea
> > to humor the users by checking for errors at
> > critical points in your program.
> > -Robert D. Schneider, "Optimizing INFORMIX
> > Applications"
> >
> >
> >
>
>
Received on Thu Jun 05 2003 - 22:20:15 CDT