Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: DO or DONT Analyze SYS Objects ?
"Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message
news:p2ml2uspfep93agpenvc7ujhv5nm76v0kh_at_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
See this on 'AskTom' - Tom is the best.
The second response after the original question is relevant to your question. If the link line-breaks, just reconstruct it - sorry.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:220289133 2282
HTH,
This message was cancelled from within Mozilla...not Received on Fri Dec 28 2001 - 20:00:42 CST