Corrupted Indexes

Posted on 2014-02-21
Medium Priority
Last Modified: 2014-04-22
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 ?


Question by:joe_echavarria
LVL 23

Expert Comment

ID: 39877903
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.
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39884963
if the indexes are in invalid state, then probably worth a try to rebuild them to see if that helps.

LVL 10

Accepted Solution

dbmullen earned 2000 total points
ID: 39932697
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
LVL 23

Expert Comment

ID: 39933136
Joe, any new comments?

Author Comment

ID: 40015333
The below parameters were increase and the performance improved.

show parameter sga_max_size

show parameter sga_target

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question