Home » RDBMS Server » Server Administration » index stats
index stats [message #162785] Mon, 13 March 2006 11:43 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
I used the following command for analysing corruption in an index, ANALYZE INDEX [ schema.]index VALIDATE STRUCTURE

What are the columns from index_stats, that I, should be looking for this.

Report message to a moderator

Re: index stats [message #162819 is a reply to message #162785] Mon, 13 March 2006 14:27 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4214.htm

Report message to a moderator

Previous Topic: dba_data_files
Next Topic: alert log file message
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:38:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.