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

DO or DONT Analyze SYS Objects ?

From: Andreas Wizemann <AWizemann_at_fvvag.de>
Date: Thu, 27 Dec 2001 09:17:22 +0100
Message-ID: <p2ml2uspfep93agpenvc7ujhv5nm76v0kh@4ax.com>


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 Received on Thu Dec 27 2001 - 02:17:22 CST

Original text of this message

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