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: spencer <spencerp_at_swbell.net>
Date: Sat, 18 Nov 2000 11:16:28 -0600
Message-ID: <FPyR5.85$ud3.13501@nnrp3.sbc.net> 






<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

>




i believe oracle advises (for performance reasons) that you
not collect statistics on any tables owned by SYS.
Received on Sat Nov 18 2000 - 11:16:28 CST












Original text of this message













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