• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

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
0
joe_echavarria
Asked:
joe_echavarria
1 Solution
 
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
 
dbmullenCommented:
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:
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

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now