Re: Analyze question - data corruption

In article <20000327141226.01940.00009253_at_ng-dc1.aol.com>, mannymac_at_aol.com (MannyMac) wrote:
> Hello
>
> I am new to oracle and I am trying to check for data block corruption,
 our
> software vendor suggests to use analyze in the following format:
>
> analyze table (table name) validate structure cascade:
>
> so I am trying to put a script together to check for all the tables on
 the
> database, my questions are as follows:
>
> 1. I am assuming that oracle has to be up, but does the system has to
 be
> cleared of users?? or this can be done while the dataabase is up and
 being used
> by people during the day?
>
> 2. running select * from dba_tables gives me more than 2,600 tables
 owned by 7
> accounts. Instead of doing the analyze one by one, is there a more
 efficient
> way of checking all these tables? I know there is a
 dbms_utility.analyze_schema
> to analyze objects by user, but I am not quite sure how to use it. The
> dbmsutil.sql doesn't seem to help me much.
>
> any help will be greatly appretiated
> Manny
> chavez_at_dkfny.com
>
>

• The analyze can be done during the day
• Generate your Analyze by using a script such as

set heading off
Spool analyze.sql
select 'analyze table' || owner || '.' || table_name || 'validate structure cascade:' where owner not in ('SYS','SYSTEM'); spool off

sqlplus uid/pwd_at_svc @analyze.sql

• To check for block corruption try running the DBVERF command against the tablespaces. The tablespace must be offline for this.

enjoy.......

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com http://www.deja.com/
Before you buy.