Re: How to check corruption in system tablespace

From: <jdarrah_co_at_my-deja.com>
Date: Mon, 20 Nov 2000 17:21:20 GMT
Message-ID: <8vbmi7$k4g$1@nnrp1.deja.com>

Just to clarify, this statement does not gather stats on the tables, it only validates their structure. Example:

SQL> analyze table uet$ validate structure cascade;

Table analyzed.

SQL> select last_analyzed from dba_tables where table_name = 'UET$' 2 /

LAST_ANAL

In article <FPyR5.85$ud3.13501_at_nnrp3.sbc.net>, "spencer" <spencerp_at_swbell.net> wrote:
> <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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 20 2000 - 11:21:20 CST