joe_echavarria
asked on
Corrupted Indexes
Hi ,
The application provider says to me that he think we have corrupted indexes in the database.
How can i check if there are corrupted indexes in the database ?
Regards,
Joe
The application provider says to me that he think we have corrupted indexes in the database.
How can i check if there are corrupted indexes in the database ?
Regards,
Joe
if the indexes are in invalid state, then probably worth a try to rebuild them to see if that helps.
Thanks,
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Joe, any new comments?
ASKER
The below parameters were increase and the performance improved.
show parameter sga_max_size
show parameter sga_target
show parameter sga_max_size
show parameter sga_target
alter index index_name validate structure;
and the full monty is here at docs.oracle: http://docs.oracle.com/cd/B28359_01/server.111/b28310/general002.htm#ADMIN11524.