Solved

Corrupted Indexes

Posted on 2014-02-21
5
151 Views
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 ?

  Regards,

   Joe
0
Comment
Question by:joe_echavarria
5 Comments
 
LVL 23

Expert Comment

by:David
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.
0
 
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.

Thanks,
0
 
LVL 10

Accepted Solution

by:
dbmullen earned 500 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
0
 
LVL 23

Expert Comment

by:David
ID: 39933136
Joe, any new comments?
0
 
LVL 1

Author Comment

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

show parameter sga_max_size

show parameter sga_target
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
levels for reporting 5 50
return result by latest date - oracle query 21 48
Oracle Subquery bad Join 11 42
dates - loop 12 41
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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
Via a live example, show how to take different types of Oracle backups using RMAN.

708 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now