Re: ANALYZE command

Oracle state you should *not* analyze the SYS and SYSTEM schemas. Are you sure someone hasn't installed their own stuff (or a bought in package) in there?

I should imagine Oracle built the SYS data dictionary with RBO, no CBO in mind, as the the CBO is relatively new in comaprison. Hence the CBO might throw it out of tune. I'm guessing here, but it seems reasonable. And if Oracle say don't do it, then don't do it. And I run 1TB of Oracle databases on Oracle 7 & 8 without any problems, having never analyzed SYS or SYSTEM.

MotoX.

On Tue, 15 Dec 1998 10:15:24 GMT, alt_at_interchange.co.uk wrote:

>Hi
>
>Oracle 7.3.2.3 on Dec Alpha
>
>I've recently taken over the role of DBA at my company and I've found a script
>thats performing an ANALYZE of the SYS and SYSTEM tables on a weekly basis.
>
>I seem to recall (but cant find any reference in a manual) that you're not
>supposed to do this. Could you tell me if my recolection is correct and if so
>why!
>
>I'd be grateful for a reply by email - thanks for the help
>
>alt_at_interchange.co.uk
>
>Al
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 15 1998 - 14:29:49 CST