Re: Statistics

You should NEVER analyze sys.
The dictionary was developed years ago, when the CBO didn't even exist. It has been optimized for the rule-based optimizer, on which Oracle stopped development with the first release of 7. It is still there though, and used by all recursive (dictionary) sql.

Hth,

--
Sybrand Bakker, Oracle DBA
Stephan Hartmann <Stephan_Hartmann_at_t-online.de> wrote in message news:836gkh$s53$1_at_news06.btx.dtag.de...
> We were running our programm on Oracle 7.3.4
> without statistics.
>
> To increase the performance we analyzed the the tables.
> The result was that some querys get faster, but some get slower.
>
> In Oracle HTML-Help you can read that you should set
> OPTIMIZER GOAL to First Rows if you ' re running an interactive
application
> and all Rows if f you're not interactive ynd you want to safe resources.
>
> The FIRST ROWS Parameter works fine on our datatables, but each access of
> the oracle
> datadictionairy is very slow now. We're programming in Delphi, and the
> Delphi BDE uses
> the Datadictionairy excessively.
>
> Why is Oracle using the same optimizer mode for his own datadictionairy
> tables and the user data,
>
> or where is our fault ?
>
> regards
>
> Stephan
>
>
>
Received on Wed Dec 15 1999 - 12:18:01 CST