Re: ANALYZE on SYS / SYSTEM

Hi,

• Compute/estimate statistics will lock your dictionary tables and prevent things like create table etc.
• Dictionarytables change very very often, so you statistics will be useless within a very short period.

grt

alt_at_interchange.co.uk wrote:

> Hi
>
> Oracle 7.3.2.3 on Dec UNIX
>
> I wonder if someone could advise me on whether or not it's a good idea to use
> the ANALYZE command against the SYS and SYSTEM schemas. I seem to remember
> that your not supposed to do this but I can't think why and I can't see any
> indication in the Server Admininistrators Guide one way or the other. The
> reason I ask is that someone has already done this on the server and it
> doesn't seem to have had an impact - I hope!
>
> Thanks in advance for any advice.
>
> Please email response to 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 Wed Dec 16 1998 - 16:39:45 CST