We are using Oracle 10g. At fresh the DB was really fast, and day by day the processing of records getting slower and slower. In 14 months the database takes twice the amount of time it was taking earlier
Activities done on the database are:
1) Daily there is a insert of around 150K records.
2) Delete the records which are inserted 18 months old.
3) Selection of records using the indexed column in the condition clause.
I tried rebuilding the index and recomputed the statistic also.
Can you please give some ideas what else can be done so the performance can be improved.
you should work out what you are waiting on
Utilizes Oracles Automatic Workload Repository (AWR) to collect performance statistics
Click Here to Expand Forum to Full Width