Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ANALYZE VALIDATE STRUCTURE;

user3266490Mar 24 2010 — edited Mar 24 2010

Hi,

executed the followings

ANALYZE TABLE employee VALIDATE STRUCTURE;

The above used to find block corruption.

is it reactive method?

if it's,any proactive method for find the block corruption?

and
compute statistics and estimated statistics both are same?

is there any difference between them?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2010

Added on Mar 24 2010

#general-database-discussions

14 comments

6,899 views