Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Statistics

Re: Statistics

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 15 Dec 1999 19:18:01 +0100
Message-ID: <945281934.10719.0.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US