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 -> Re: dropping analyze objects from data dictionary

Re: dropping analyze objects from data dictionary

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Tue, 29 Jul 2003 13:30:02 +0200
Message-ID: <MPG.1990792471148a939896bb@iww.cacti.ch.alstom.com> 





In article <uipaivonlc13nda2d6o4cl9kfpsvi5nlbe_at_4ax.com>, 
gooiditweg_at_sybrandb.demon.nl says...



[...]



> You should simply in 8i NEVER EVER ANALYZE sys and system.




OK, and if I do a



dbms_stats.gather_database_stats( cascade => true )



It shouldn't analyse the sys .. right?



-- 
mfg
Marc Eggenberger


Received on Tue Jul 29 2003 - 06:30:02 CDT












Original text of this message













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