DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle slowness

  1. #1
    Join Date
    May 2007
    Posts
    1

    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
    Location
    England
    Posts
    7,334
    you should work out what you are waiting on

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

    Link

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