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
LVL 1
joe_echavarriaDatabase AdministratorAsked:
Who is Participating?
 
dbmullenConnect With a Mentor Commented:
translation, it's slow and they don't know why..  
ask them for how much memory should be allocated to the database/server
then, see if you can increase it.
show parameter memory_max_target
show parameter memory_target
show parameter sga_max_size
show parameter sga_target
show parameter pga_aggregate_target
0
 
DavidSenior Oracle Database AdministratorCommented:
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.
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
if the indexes are in invalid state, then probably worth a try to rebuild them to see if that helps.

Thanks,
0
 
DavidSenior Oracle Database AdministratorCommented:
Joe, any new comments?
0
 
joe_echavarriaDatabase AdministratorAuthor Commented:
The below parameters were increase and the performance improved.

show parameter sga_max_size

show parameter sga_target
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.