Re: DO or DONT Analyze SYS Objects ?

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Sat, 29 Dec 2001 02:00:42 GMT
Message-ID: <et9X7.31598$Z03.18503854@news1.rdc1.mi.home.com>

"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,

Received on Fri Dec 28 2001 - 20:00:42 CST