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: How to check corruption in system tablespace

Re: How to check corruption in system tablespace

From: Brian McKerr <bmckerr_at_hotmail.com>
Date: Sun, 19 Nov 2000 01:46:12 +1000
Message-ID: <8v6885$15uq$1@corolla.OntheNet.com.au> 






I think they mean do not analyze for statistical reasons , eg do *NOT* run
'analyze table X estimate/compute statistics' or the likes !




Cheers,





<ashish25_at_my-deja.com> wrote in message news:8v614a$gmh$1_at_nnrp1.deja.com...


> Hi ,

>   As per that note I can analyze Sys tables but as far as I remeber

> Oracle advices not to analyze any sys tables.

>    If I do this analyze for checking corrpution will it impact

> anything??

> Thanks,

> Ashish

>

Received on Sat Nov 18 2000 - 09:46:12 CST












Original text of this message













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