Link to home
Start Free TrialLog in
Avatar of joe_echavarria
joe_echavarriaFlag for Dominican Republic

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
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

This would be rare, but the basic syntax per index is:

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.
if the indexes are in invalid state, then probably worth a try to rebuild them to see if that helps.

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of dbmullen
dbmullen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Joe, any new comments?
Avatar of joe_echavarria

ASKER

The below parameters were increase and the performance improved.

show parameter sga_max_size

show parameter sga_target