DB slow down
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DB slow down

  1. #1
    Join Date
    Feb 2001
    Posts
    5
    One of the application windows opens really slow (around 20s). After restarting the database same window takes below 2s to open. After running the system for a few days it slows down again. From that window same rows are updated many times.

    What should I look for to find out why this is slowing down?

    Katarina

  2. #2

    Wink DB Slow Down

    You have to know how many users are using the same application opening windows on different machines.
    Check the redolog activities.
    Queyon Zeng

  3. #3
    Join Date
    Feb 2001
    Posts
    5
    This is happening on the test database and I had the chance to get all the users of the database to try it myself. It happens even when I'm the only one accessing the whole database.

    Katarina

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Start here http://technet.oracle.com/deploy/per...rf_method1.pdf

    If you have more specific questions about the various ratios, please post another thread.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Feb 2001
    Posts
    5
    Jeff, the document you suggested was not of much help.
    Test was done with only one user on the system. CPU usage is below 10%. Window opens fast after restarting database, meaning there is nothing wrong with I/O or full table scans or disc sorting. It is not optimizer problem or row migration problem either than it would run slow after restarting the database. It is only that it slows down after it is accessed many times (it does update, not the insert).


    Katarina

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You most likely have a memory issue. Start your database with timed_statistics=true, run it until it starts to slow down, and run a bstat/estat report. This will give you some more information on what exactly is going wrong...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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