Oracle slowness Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle slowness

  1. #1
    Join Date
    May 2007

    Oracle slowness

    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.

  2. #2
    Join Date
    Sep 2002
    you should work out what you are waiting on

  3. #3
    Join Date
    May 2007
    Utilizes Oracles Automatic Workload Repository (AWR) to collect performance statistics


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width