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 -> ANALYZE on SYS / SYSTEM

ANALYZE on SYS / SYSTEM

From: <alt_at_interchange.co.uk>
Date: Fri, 11 Dec 1998 17:00:20 GMT
Message-ID: <74rj32$t3b$1@nnrp1.dejanews.com>


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 Fri Dec 11 1998 - 11:00:20 CST

Original text of this message

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