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: REPOST: DO or DONT Analyze SYS Objects ?

Re: REPOST: DO or DONT Analyze SYS Objects ?

From: Hieraklion <hieraklion_at_spray.fr>
Date: Wed, 02 Jan 2002 12:16:08 +0100
Message-ID: <3C32EBF8.6060909@spray.fr>


"Bonjour" from Paris,

1/ No general answer. It depends your database modification. The aim of analyze is to have a correct view of the data. Some datas needs compute (generaly ; heterogeneous data in a same object) or estimate ( homogeneous datas in a object).

Example : a big index on a single colum is generally correct for a estimate.

                a big table with number, varchar, lob, date with 
potential linked records or a lot of
                 modifications can be estimate if the modifications 
'seems like' the rest of the table, else                     compute ...

2/ NEVER analyze system or sys objects. It's the best way to change the right kernel way of life !

"Au revoir" from Paris
Hieraklion

Andreas Wizemann wrote:

>Hello,
>
>we are running Oracle 8171 using the CBO (Cost Based Optimizer).
>I'm currently setting up a cron job to do a analyze on "all" objects
>on a regular basis.
>Now i have 2 Questions:
>
>1) Do i need to use COMPUTE STATISTICS or should i use ESTIMATE (?
>rows or ? Percent)
>
>2) What about Objects from user SYS ? Analyzing or not ?
>
>Any Hints ?
>Thanks
>
>Andreas Wizemann
>
>========= WAS CANCELLED BY =======:
>Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
>From: Andreas Wizemann <AWizemann_at_fvvag.de>
>Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
>Subject: cmsg cancel <p2ml2uspfep93agpenvc7ujhv5nm76v0kh_at_4ax.com>
>Control: cancel <p2ml2uspfep93agpenvc7ujhv5nm76v0kh_at_4ax.com>
>Date: Mon, 31 Dec 2001 06:49:20 GMT
>Organization: Navix Internet Subscribers
>Lines: 2
>Message-ID: <cancel.p2ml2uspfep93agpenvc7ujhv5nm76v0kh_at_4ax.com>
>NNTP-Posting-Host: 166.102.15.34
>X-Trace: iac5.navix.net 1009790054 28060 166.102.15.34 (31 Dec 2001 09:14:14 GMT)
>X-Complaints-To: abuse_at_navix.net
>NNTP-Posting-Date: 31 Dec 2001 09:14:14 GMT
>X-No-Archive: yes
>Comment: Anarchy! Fuck You!
>X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
>X-Unacanc3l: yes
>
>This message was cancelled from within Mozilla...not
>
Received on Wed Jan 02 2002 - 05:16:08 CST

Original text of this message

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